{"id":2855,"date":"2023-07-20T09:39:00","date_gmt":"2023-07-20T09:39:00","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/"},"modified":"2023-07-20T09:39:00","modified_gmt":"2023-07-20T09:39:00","slug":"excel-sumif-vs-sumif","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/","title":{"rendered":"Sumif vs sumifs di excel: apa bedanya?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Di Excel, fungsi <strong>SUMIF<\/strong> dan <b>SUMIFS<\/b> keduanya menjumlahkan sel dalam rentang yang memenuhi kondisi tertentu, namun menggunakan perilaku yang sedikit berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Fungsi <b>SUMIF<\/b> menjumlahkan jumlah sel dalam rentang yang memenuhi <strong>suatu kondisi<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Fungsi <b>SUMIFS<\/b> menghitung jumlah sel dalam rentang yang memenuhi <strong>beberapa kondisi<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap fungsi dalam praktik dengan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25003 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumif_vs1.jpg\" alt=\"\" width=\"472\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menggunakan SUMIF<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus <b>SUMIF<\/b> berikut untuk menjumlahkan nilai pada kolom Points dimana nilai pada kolom Team sama dengan \u201cMavs\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIF( <span style=\"color: #3366ff;\">A2:A16<\/span> , \"Mavs\", <span style=\"color: #ff0000;\">C2:C16<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25004 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumif_vs2.jpg\" alt=\"\" width=\"514\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Jumlah poin untuk garis dimana tim sama dengan &#8220;Mavs&#8221; adalah <strong>86<\/strong> .<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menggunakan SUMIFS<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus <strong>SUMIFS<\/strong> berikut untuk menjumlahkan nilai pada kolom Points dimana nilai kolom Team sama dengan \u201cMavs\u201d dan nilai kolom Rebounds lebih besar dari 5:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIFS( <span style=\"color: #3366ff;\">C2:C16<\/span> , <span style=\"color: #ff0000;\">A2:A16<\/span> , \"Mavs\", <span style=\"color: #800080;\">B2:B16<\/span> , \"&gt;5\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25005 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumif_vs3.jpg\" alt=\"\" width=\"612\" height=\"501\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin untuk garis dimana tim sama dengan &#8220;Mavs&#8221; dan rebound lebih besar dari 5 adalah <strong>51<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Lihat halaman dokumentasi Excel untuk penjelasan lengkap mengenai fungsi <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sumif-function-169b8c99-c05c-4483-a712-1697a653039b\" target=\"_blank\" rel=\"noopener\">SUMIF<\/a> dan <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b\" target=\"_blank\" rel=\"noopener\">SUMIFS<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/sumif-atau-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIF dengan OR di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-sumif-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIFS dengan rentang tanggal di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sumif-joker\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan wildcard pada fungsi SUMIFS di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Di Excel, fungsi SUMIF dan SUMIFS keduanya menjumlahkan sel dalam rentang yang memenuhi kondisi tertentu, namun menggunakan perilaku yang sedikit berbeda: Fungsi SUMIF menjumlahkan jumlah sel dalam rentang yang memenuhi suatu kondisi . Fungsi SUMIFS menghitung jumlah sel dalam rentang yang memenuhi beberapa kondisi . Contoh berikut memperlihatkan cara menggunakan setiap fungsi dalam praktik dengan [&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>SUMIF vs SUMIFS di Excel: Apa bedanya? - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi SUMIF dan SUMIFS di Excel, beserta contohnya.\" \/>\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\/excel-sumif-vs-sumif\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SUMIF vs SUMIFS di Excel: Apa bedanya? - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi SUMIF dan SUMIFS di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T09:39:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumif_vs1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/\",\"name\":\"SUMIF vs SUMIFS di Excel: Apa bedanya? - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T09:39:00+00:00\",\"dateModified\":\"2023-07-20T09:39:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi SUMIF dan SUMIFS di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sumif vs sumifs di excel: apa bedanya?\"}]},{\"@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":"SUMIF vs SUMIFS di Excel: Apa bedanya? - Statologi","description":"Tutorial ini menjelaskan perbedaan fungsi SUMIF dan SUMIFS di Excel, beserta contohnya.","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\/excel-sumif-vs-sumif\/","og_locale":"id_ID","og_type":"article","og_title":"SUMIF vs SUMIFS di Excel: Apa bedanya? - Statologi","og_description":"Tutorial ini menjelaskan perbedaan fungsi SUMIF dan SUMIFS di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/","og_site_name":"Statorials","article_published_time":"2023-07-20T09:39:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumif_vs1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/","url":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/","name":"SUMIF vs SUMIFS di Excel: Apa bedanya? - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T09:39:00+00:00","dateModified":"2023-07-20T09:39:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi SUMIF dan SUMIFS di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-sumif-vs-sumif\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sumif vs sumifs di excel: apa bedanya?"}]},{"@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\/2855"}],"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=2855"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2855\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}