{"id":4322,"date":"2023-07-12T00:33:26","date_gmt":"2023-07-12T00:33:26","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-vba\/"},"modified":"2023-07-12T00:33:26","modified_gmt":"2023-07-12T00:33:26","slug":"jumlah-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-vba\/","title":{"rendered":"Vba: cara menulis fungsi sumif dan sumifs"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan metode berikut untuk menulis fungsi SUMIF dan SUMIFS menggunakan VBA di Excel:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Metode 1: Fungsi SUMIF di VBA<\/span><\/strong><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubSumif_Function<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">E2<\/span> \") = WorksheetFunction.Sumif(Range(\" <span style=\"color: #ff0000;\">A2:A12<\/span> \"), \" <span style=\"color: #ff0000;\">Mavs<\/span> \", Range(\" <span style=\"color: #ff0000;\">B2:B12<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan menjumlahkan nilai dalam rentang <strong>B2:B12<\/strong> hanya jika nilai terkait dalam rentang <strong>A2:A12<\/strong> sama dengan &#8220;Mavs&#8221; dan menetapkan hasilnya ke sel <strong>E2<\/strong> .<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Metode 2: Fungsi SUMIFS di VBA<\/span><\/strong><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> Sumifs_Function()\n    Range(\" <span style=\"color: #ff0000;\">E2<\/span> \") = WorksheetFunction.SumIfs(Range(\" <span style=\"color: #ff0000;\">C2:C12<\/span> \"), Range(\" <span style=\"color: #ff0000;\">A2:A12<\/span> \"), \" <span style=\"color: #ff0000;\">Mavs<\/span> \", Range(\" <span style=\"color: #ff0000;\">B2:B12<\/span> \"), \" <span style=\"color: #ff0000;\">&gt;20<\/span> \")\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan menjumlahkan nilai dalam rentang <strong>C2:C12<\/strong> hanya jika nilai dalam rentang <strong>A2:A12<\/strong> sama dengan &#8220;Mavs&#8221; <em>dan<\/em> nilai dalam rentang <strong>B2:B12<\/strong> lebih besar dari 20, lalu tetapkan hasilnya ke sel <strong>E2<\/strong> . .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan himpunan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33966 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif1.jpg\" alt=\"\" width=\"496\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Contoh 1: Fungsi SUMIF di VBA<\/span><\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghitung penjumlahan nilai pada kolom poin hanya untuk pemain yang berada di tim Mavs saja.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk menjalankan fungsi SUMIF ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubSumif_Function<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">E2<\/span> \") = WorksheetFunction.Sumif(Range(\" <span style=\"color: #ff0000;\">A2:A12<\/span> \"), \" <span style=\"color: #ff0000;\">Mavs<\/span> \", Range(\" <span style=\"color: #ff0000;\">B2:B12<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33968 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif2.jpg\" alt=\"\" width=\"496\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <strong>E2<\/strong> berisi nilai <strong>73<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini mewakili penjumlahan nilai pada kolom poin pemain tim Mavs.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan menghitung secara manual jumlah nilai di kolom poin untuk pemain tim Mavs:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin untuk pemain Mavs: 22 + 10 + 29 + 12 = <strong>73<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Fungsi SUMIFS di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghitung jumlah nilai pada kolom assist hanya untuk pemain yang memenuhi kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain adalah bagian dari tim Mavs.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain mencetak lebih dari 20 poin.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk menjalankan fungsi SUMIFS ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> Sumifs_Function()\n    Range(\" <span style=\"color: #ff0000;\">E2<\/span> \") = WorksheetFunction.SumIfs(Range(\" <span style=\"color: #ff0000;\">C2:C12<\/span> \"), Range(\" <span style=\"color: #ff0000;\">A2:A12<\/span> \"), \" <span style=\"color: #ff0000;\">Mavs<\/span> \", Range(\" <span style=\"color: #ff0000;\">B2:B12<\/span> \"), \" <span style=\"color: #ff0000;\">&gt;20<\/span> \")\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33969 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif3.jpg\" alt=\"\" width=\"506\" height=\"477\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <strong>E2<\/strong> berisi nilai <strong>18<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini mewakili penjumlahan nilai pada kolom poin untuk pemain tim Mavs yang mencetak lebih dari 20 poin.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kami membuat fungsi SUMIFS menggunakan dua rentang kriteria tetapi Anda dapat menggunakan rentang kriteria sebanyak yang Anda inginkan dalam metode <strong>WorksheetFunction.SumIfs<\/strong> .<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-vba-jika\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan metode berikut untuk menulis fungsi SUMIF dan SUMIFS menggunakan VBA di Excel: Metode 1: Fungsi SUMIF di VBA SubSumif_Function () Range(&#8221; E2 &#8220;) = WorksheetFunction.Sumif(Range(&#8221; A2:A12 &#8220;), &#8221; Mavs &#8220;, Range(&#8221; B2:B12 &#8220;)) End Sub Contoh khusus ini akan menjumlahkan nilai dalam rentang B2:B12 hanya jika nilai terkait dalam rentang A2:A12 sama [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menulis fungsi SUMIF dan SUMIFS - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menulis fungsi SUMIF dan SUMIFS di VBA, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menulis fungsi SUMIF dan SUMIFS - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menulis fungsi SUMIF dan SUMIFS di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T00:33:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-vba\/\",\"name\":\"VBA: Cara menulis fungsi SUMIF dan SUMIFS - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T00:33:26+00:00\",\"dateModified\":\"2023-07-12T00:33:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menulis fungsi SUMIF dan SUMIFS di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menulis fungsi sumif dan sumifs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara menulis fungsi SUMIF dan SUMIFS - Statorial","description":"Tutorial ini menjelaskan cara menulis fungsi SUMIF dan SUMIFS di VBA, dengan beberapa contoh.","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:\/\/statorials.org\/id\/jumlah-vba\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menulis fungsi SUMIF dan SUMIFS - Statorial","og_description":"Tutorial ini menjelaskan cara menulis fungsi SUMIF dan SUMIFS di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/jumlah-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-12T00:33:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/jumlah-vba\/","url":"https:\/\/statorials.org\/id\/jumlah-vba\/","name":"VBA: Cara menulis fungsi SUMIF dan SUMIFS - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T00:33:26+00:00","dateModified":"2023-07-12T00:33:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menulis fungsi SUMIF dan SUMIFS di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menulis fungsi sumif dan sumifs"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4322"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4322"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4322\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}