{"id":1737,"date":"2023-11-08T19:55:38","date_gmt":"2023-11-08T19:55:38","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/"},"modified":"2023-12-06T06:16:16","modified_gmt":"2023-12-06T06:16:16","slug":"sumif-vlookup","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/","title":{"rendered":"Bagaimana cara menggabungkan vlookup dengan sumif?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2191143358\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Ya, Anda bisa menggabungkan VLOOKUP dan SUMIF. Di SUMIF terdapat argumen kriteria di mana Anda dapat menggunakan VLOOKUP untuk membuat nilai dinamis. Ini memungkinkan Anda mengubah kriteria dengan mengubah nilai pencarian di VLOOKUP. Penggunaan formula gabungan ini unik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77842\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"gabungkan-vlookup-dengan-sumif\" width=\"578\" height=\"526\"><\/figure><\/div><p> Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP untuk membuat rumus.<\/p><h2 class=\"wp-block-heading\"> Menggabungkan SUMIF dan VLOOKUP<\/h2><ol type=\"1\"><li> Pertama, di dalam sel, masukkan \u201c=SUMIF(\u201c, untuk argumen rentang, lihat rentang ID produk yang Anda miliki di Tabel 1.<\/li><li> Setelah itu, pada augmentasi kedua, Anda perlu menggunakan fungsi VLOOKUP untuk mencari ID produk menggunakan nama produk pada sel di atas.<\/li><li> Lalu, pada argumen ketiga SUMIF, lihat kolom kuantitas yang akan digunakan sebagai sum_range.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77843\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sumif-et-vlookup-combines.png\" sizes=\"auto, \" srcset=\"\" alt=\"gabungan sumif-dan-vlookup\" width=\"567\" height=\"349\"><\/figure><\/div><p class=\"formula\"> =SUMIF(A2:A13,VLOOKUP(B15,D1:E7,2,0),B2:B13) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77845\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-avec-formule-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-dengan-vlookup-rumus\" width=\"619\" height=\"83\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Mari kita bagi rumus ini menjadi tiga bagian: Pada bagian pertama, Anda menentukan rentang lokasi ID produk. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77846\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-4-sumif-premiere-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-sumif-bagian pertama\" width=\"536\" height=\"389\"><\/figure><\/div><p> Di bagian kedua, Anda memiliki VLOOKUP yang mengambil nama produk dari sel B15 dan mencarinya di tabel2. Untuk headphone kami memiliki ID produk OT-356. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77847\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-vlookup-en-deuxieme-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup-di-bagian-kedua\" width=\"557\" height=\"417\"><\/figure><\/div><p> Di bagian ketiga, kita memiliki kolom kuantitas sebagai sum_range. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77848\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-troisieme-partie-contient-la-plage-de-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"bagian ketiga berisi rentang jumlah\" width=\"566\" height=\"419\"><\/figure><\/div><p> Singkatnya, VLOOKUP membantu Anda menemukan ID produk dengan nama produk, kemudian SUMIF mengambil ID produk tersebut dan mencarinya di kolom ID Produk, lalu menjumlahkan nilainya di kolom Quantity.<\/p><p> Seperti yang saya katakan, ketika Anda menggunakan SUMIF dan VLOOKUP, rumus Anda akan menjadi rumus yang dinamis. Saat Anda mengubah nama produk di sel, hasilnya akan berubah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77849\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumif-vlookup-rend-la-formule-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-vlookup-make-dynamic-formula\" width=\"570\" height=\"350\"><\/figure><\/div><h2 class=\"wp-block-heading\"> SUMIF dan VLOOKUP dalam beberapa lembar<\/h2><p> Anda dapat menggunakan kombinasi ini bahkan ketika Anda memiliki dua tabel di beberapa lembar berbeda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77850\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumif-vlookup-dans-plusieurs-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-vlookup-dalam-beberapa-lembar\" width=\"572\" height=\"421\"><\/figure><\/div><p> Pada contoh di atas, Anda memiliki tabel nama produk pada lembar berbeda. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/sumif-vlookup-3.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/\">Jumlahnya lebih besar dari nilai menggunakan SUMIF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\">Jumlah nilai yang tidak sama (SUMIFS) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-sumif-atau-logika\/\">SUMIF\/SUMIFS dengan logika OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-dengan-wildcard\/\">SUMIF dengan wildcard di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-nilai-antara-dua-tanggal\/\">Rentang tanggal SUMIFS (jumlah nilai antara dua array tanggal)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1737","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggabungkan VLOOKUP dengan SUMIF?<\/title>\n<meta name=\"description\" content=\"Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP. Kombinasi fungsi ini memungkinkan Anda untuk berubah\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggabungkan VLOOKUP dengan SUMIF?\" \/>\n<meta property=\"og:description\" content=\"Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP. Kombinasi fungsi ini memungkinkan Anda untuk berubah\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/\",\"name\":\"Bagaimana cara menggabungkan VLOOKUP dengan SUMIF?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\",\"datePublished\":\"2023-11-08T19:55:38+00:00\",\"dateModified\":\"2023-12-06T06:16:16+00:00\",\"description\":\"Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP. Kombinasi fungsi ini memungkinkan Anda untuk berubah\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggabungkan vlookup dengan sumif?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggabungkan VLOOKUP dengan SUMIF?","description":"Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP. Kombinasi fungsi ini memungkinkan Anda untuk berubah","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggabungkan VLOOKUP dengan SUMIF?","og_description":"Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP. Kombinasi fungsi ini memungkinkan Anda untuk berubah","og_url":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/","url":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/","name":"Bagaimana cara menggabungkan VLOOKUP dengan SUMIF?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png","datePublished":"2023-11-08T19:55:38+00:00","dateModified":"2023-12-06T06:16:16+00:00","description":"Pada tutorial ini, kita akan mempelajari cara menggabungkan SUMIF dan VLOOKUP. Kombinasi fungsi ini memungkinkan Anda untuk berubah","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sumif-vlookup\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggabungkan vlookup dengan sumif?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1737"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1737\/revisions"}],"predecessor-version":[{"id":2513,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1737\/revisions\/2513"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}