{"id":2734,"date":"2023-07-20T23:11:54","date_gmt":"2023-07-20T23:11:54","guid":{"rendered":"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/"},"modified":"2023-07-20T23:11:54","modified_gmt":"2023-07-20T23:11:54","slug":"menghitung-vs-menghitung-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/","title":{"rendered":"Count vs counta di excel: apa bedanya?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Di Excel, fungsi <strong>COUNT<\/strong> dan <strong>COUNTA<\/strong> menghitung jumlah sel dalam suatu rentang, namun menggunakan perilaku yang sedikit berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Fungsi <strong>COUNT<\/strong> menghitung jumlah sel dalam rentang yang berisi angka.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Fungsi <strong>COUNTA<\/strong> menghitung jumlah sel dalam rentang yang tidak kosong.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Fungsi <strong>COUNT<\/strong> berguna untuk menghitung jumlah sel dalam rentang yang berisi nilai <em>numerik<\/em> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>COUNTA<\/strong> berguna untuk menghitung jumlah sel dalam rentang yang berisi nilai <em>apa pun<\/em> .<\/span><\/p>\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: Semua nilai dalam rentang tersebut adalah numerik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita menggunakan fungsi <strong>COUNT<\/strong> dan <strong>COUTNA<\/strong> untuk menghitung jumlah<\/span> <span style=\"color: #000000;\">sel dalam rentang yang setiap selnya berupa angka (atau kosong), kedua fungsi tersebut akan mengembalikan nilai yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24079 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-2.jpg\" alt=\"\" width=\"576\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam hal ini, kolom <strong>Penjualan<\/strong> berisi 9 sel yang berisi nilai numerik dan satu sel kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>COUNT<\/strong> memberitahu kita bahwa ada 9 sel dengan nilai <em>numerik<\/em> di kolom Penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>COUNTA<\/strong> memberitahu kita bahwa ada 9 sel dengan nilai <em>berapa pun<\/em> di kolom Penjualan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Beberapa nilai dalam rentang tersebut bukan numerik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita menggunakan fungsi <strong>COUNT<\/strong> dan <strong>COUTNA<\/strong> untuk menghitung jumlah<\/span> <span style=\"color: #000000;\">sel dalam rentang yang beberapa selnya bukan numerik, kedua fungsi tersebut akan mengembalikan nilai yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24080 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2-3.jpg\" alt=\"\" width=\"524\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam hal ini, kolom <strong>Penjualan<\/strong> berisi tujuh sel berisi nilai numerik, dua sel berisi nilai karakter, dan satu sel kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>COUNT<\/strong> memberitahu kita bahwa ada 7 sel dengan nilai <em>numerik<\/em> di kolom Penjualan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi <strong>COUNTA<\/strong> memberitahu kita bahwa ada 9 sel dengan nilai <em>berapa pun<\/em> di kolom Penjualan.<\/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\/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>Di Excel, fungsi COUNT dan COUNTA menghitung jumlah sel dalam suatu rentang, namun menggunakan perilaku yang sedikit berbeda: Fungsi COUNT menghitung jumlah sel dalam rentang yang berisi angka. Fungsi COUNTA menghitung jumlah sel dalam rentang yang tidak kosong. Fungsi COUNT berguna untuk menghitung jumlah sel dalam rentang yang berisi nilai numerik . Fungsi COUNTA berguna [&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>COUNT vs COUNTA di Excel: Apa bedanya? - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi COUNT dan COUNTA 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\/menghitung-vs-menghitung-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"COUNT vs COUNTA di Excel: Apa bedanya? - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi COUNT dan COUNTA di Excel beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T23:11:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-2.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\/menghitung-vs-menghitung-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/\",\"name\":\"COUNT vs COUNTA di Excel: Apa bedanya? - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T23:11:54+00:00\",\"dateModified\":\"2023-07-20T23:11:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi COUNT dan COUNTA di Excel beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Count vs counta 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":"COUNT vs COUNTA di Excel: Apa bedanya? - Statorial","description":"Tutorial ini menjelaskan perbedaan fungsi COUNT dan COUNTA 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\/menghitung-vs-menghitung-excel\/","og_locale":"id_ID","og_type":"article","og_title":"COUNT vs COUNTA di Excel: Apa bedanya? - Statorial","og_description":"Tutorial ini menjelaskan perbedaan fungsi COUNT dan COUNTA di Excel beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T23:11:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-2.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\/menghitung-vs-menghitung-excel\/","url":"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/","name":"COUNT vs COUNTA di Excel: Apa bedanya? - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T23:11:54+00:00","dateModified":"2023-07-20T23:11:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi COUNT dan COUNTA di Excel beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menghitung-vs-menghitung-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Count vs counta 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\/2734"}],"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=2734"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2734\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}