{"id":2813,"date":"2023-07-20T14:19:21","date_gmt":"2023-07-20T14:19:21","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/"},"modified":"2023-07-20T14:19:21","modified_gmt":"2023-07-20T14:19:21","slug":"excel-countif-vs-countifs","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/","title":{"rendered":"Countif vs countifs di excel: apa bedanya?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Di Excel, fungsi <strong>COUNTIF<\/strong> dan <strong>COUNTIFS<\/strong> menghitung jumlah sel dalam rentang yang memenuhi kondisi tertentu, namun menggunakan perilaku yang sedikit berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Fungsi <strong>COUNTIF<\/strong> menghitung jumlah sel dalam rentang yang memenuhi <strong>suatu kondisi<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Fungsi <strong>COUNTIFS<\/strong> menghitung jumlah sel dalam rentang yang memenuhi <strong>beberapa kondisi<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap fungsi dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menggunakan COUNTIF<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus <strong>COUNTIF<\/strong> berikut untuk menghitung jumlah baris yang nilai pada rentang A2:A16 sama dengan \u201cMavs\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A16<\/span> , \"Mavs\")\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-24702 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombrevs1.jpg\" alt=\"\" width=\"517\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat melihat bahwa total <strong>5<\/strong> sel dalam rentang A2:A16 memenuhi kriteria ini.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menggunakan COUNTIFS<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus <strong>COUNTIFS<\/strong> berikut untuk menghitung jumlah baris yang nilai pada rentang A2:A16 sama dengan &#8220;Mavs&#8221; dan nilai pada rentang B2:B16 sama dengan &#8220;Guard&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIFS( <span style=\"color: #3366ff;\">A2:A16<\/span> , \"Mavs\", <span style=\"color: #ff0000;\">B2:B16<\/span> , \"Guard\")\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-24703 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombrevs2.jpg\" alt=\"\" width=\"601\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa total <strong>5<\/strong> baris dalam dataset berisi &#8220;Mavs&#8221; di kolom A dan &#8220;Guard&#8221; di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita dapat menggunakan kondisi sebanyak yang kita inginkan dalam fungsi <strong>COUNTIFS<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa menggunakan rumus berikut untuk mencari baris yang memenuhi tiga kondisi berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIFS( <span style=\"color: #3366ff;\">A2:A16<\/span> , \"Mavs\", <span style=\"color: #ff0000;\">B2:B16<\/span> , \"Guard\", <span style=\"color: #800080;\">C2:C16<\/span> , \"&gt;20\")<\/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-24704 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombrevs3.jpg\" alt=\"\" width=\"655\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa total <strong>satu<\/strong> baris kumpulan data berisi &#8220;Mavs&#8221; di kolom A, &#8220;Guard&#8221; di kolom B, dan nilai lebih besar dari 20 di kolom C.<\/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\/countif-atau-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dengan OR di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-countif-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dari sheet lain di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-rentang-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIFS dengan rentang tanggal di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Di Excel, fungsi COUNTIF dan COUNTIFS menghitung jumlah sel dalam rentang yang memenuhi kondisi tertentu, namun menggunakan perilaku yang sedikit berbeda: Fungsi COUNTIF menghitung jumlah sel dalam rentang yang memenuhi suatu kondisi . Fungsi COUNTIFS menghitung jumlah sel dalam rentang yang memenuhi beberapa kondisi . Contoh berikut menunjukkan cara menggunakan setiap fungsi dalam praktik. Contoh [&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>COUNTIF vs COUNTIFS di Excel: Apa bedanya? - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi COUNTIF dan COUNTIFS 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-countif-vs-countifs\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"COUNTIF vs COUNTIFS di Excel: Apa bedanya? - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi COUNTIF dan COUNTIFS di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:19:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombrevs1.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-countif-vs-countifs\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/\",\"name\":\"COUNTIF vs COUNTIFS di Excel: Apa bedanya? - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:19:21+00:00\",\"dateModified\":\"2023-07-20T14:19:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi COUNTIF dan COUNTIFS di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Countif vs countifs 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":"COUNTIF vs COUNTIFS di Excel: Apa bedanya? - Statologi","description":"Tutorial ini menjelaskan perbedaan fungsi COUNTIF dan COUNTIFS 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-countif-vs-countifs\/","og_locale":"id_ID","og_type":"article","og_title":"COUNTIF vs COUNTIFS di Excel: Apa bedanya? - Statologi","og_description":"Tutorial ini menjelaskan perbedaan fungsi COUNTIF dan COUNTIFS di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:19:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombrevs1.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-countif-vs-countifs\/","url":"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/","name":"COUNTIF vs COUNTIFS di Excel: Apa bedanya? - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:19:21+00:00","dateModified":"2023-07-20T14:19:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi COUNTIF dan COUNTIFS di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-countif-vs-countifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Countif vs countifs 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\/2813"}],"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=2813"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2813\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}