{"id":3834,"date":"2023-07-15T06:51:26","date_gmt":"2023-07-15T06:51:26","guid":{"rendered":"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/"},"modified":"2023-07-15T06:51:26","modified_gmt":"2023-07-15T06:51:26","slug":"akun-excel-dengan-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/","title":{"rendered":"Excel: cara menggunakan counta dengan kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>COUNTA<\/strong> di Excel untuk menghitung jumlah sel dalam rentang yang tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, terkadang Anda ingin menggunakan fungsi <strong>COUNTA<\/strong> untuk menghitung sel yang tidak kosong <em>dan<\/em> memenuhi beberapa kriteria tambahan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTA( <span style=\"color: #3366ff;\">B2:B12<\/span> )-COUNTIF( <span style=\"color: #3366ff;\">B2:B12<\/span> ,\"0\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung semua sel dalam rentang <strong>B2:B12<\/strong> yang tidak kosong <em>dan<\/em> tidak sama dengan 0.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggunakan COUNTA dengan Kriteria di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31038 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc1.jpg\" alt=\"\" width=\"413\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>COUNTA<\/strong> berikut bersama dengan fungsi <strong>COUNTIF<\/strong> untuk menghitung jumlah sel pada kolom Poin yang tidak kosong <em>dan<\/em> tidak sama dengan 0:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTA( <span style=\"color: #3366ff;\">B2:B12<\/span> )-COUNTIF( <span style=\"color: #3366ff;\">B2:B12<\/span> ,\"0\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31039 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc2.jpg\" alt=\"\" width=\"568\" height=\"527\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya terlihat ada 8 sel pada kolom Poin yang tidak kosong dan bukan nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Inilah yang sebenarnya dilakukan formula ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>COUNTA<\/strong> menghitung <strong>10<\/strong> sel kosong.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>COUNTIF<\/strong> memiliki <strong>2<\/strong> sel yang sama dengan nol.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jadi, <strong>COUNTA<\/strong> \u2013 <strong>COUNTIF<\/strong> menghasilkan <strong>10<\/strong> \u2013 <strong>2<\/strong> = <strong>8<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengganti nilai pada fungsi <strong>COUNTIF<\/strong> untuk mengecualikan nilai yang Anda inginkan dari fungsi <strong>COUNTA<\/strong> .<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung duplikat di excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/dihitung-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan kelompok di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi COUNTA di Excel untuk menghitung jumlah sel dalam rentang yang tidak kosong. Namun, terkadang Anda ingin menggunakan fungsi COUNTA untuk menghitung sel yang tidak kosong dan memenuhi beberapa kriteria tambahan. Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut: =COUNTA( B2:B12 )-COUNTIF( B2:B12 ,&#8221;0&#8243;) Rumus khusus ini menghitung semua sel dalam rentang [&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>Excel: Cara menggunakan COUNTA dengan kriteria - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTA di Excel beserta kriteria dan 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\/akun-excel-dengan-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan COUNTA dengan kriteria - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTA di Excel beserta kriteria dan contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T06:51:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc1.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\/akun-excel-dengan-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/\",\"name\":\"Excel: Cara menggunakan COUNTA dengan kriteria - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T06:51:26+00:00\",\"dateModified\":\"2023-07-15T06:51:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTA di Excel beserta kriteria dan contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan counta dengan kriteria\"}]},{\"@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":"Excel: Cara menggunakan COUNTA dengan kriteria - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTA di Excel beserta kriteria dan 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\/akun-excel-dengan-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan COUNTA dengan kriteria - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTA di Excel beserta kriteria dan contohnya.","og_url":"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-15T06:51:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc1.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\/akun-excel-dengan-kriteria\/","url":"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/","name":"Excel: Cara menggunakan COUNTA dengan kriteria - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T06:51:26+00:00","dateModified":"2023-07-15T06:51:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTA di Excel beserta kriteria dan contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/akun-excel-dengan-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan counta dengan kriteria"}]},{"@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\/3834"}],"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=3834"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3834\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}