{"id":2047,"date":"2023-10-23T00:01:03","date_gmt":"2023-10-23T00:01:03","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/"},"modified":"2023-12-06T06:12:46","modified_gmt":"2023-12-06T06:12:46","slug":"menghitung-melawan-hitungan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/","title":{"rendered":"Apa perbedaan antara count dan counta?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-941982653\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, ada dua fungsi yang sering digunakan COUNT dan COUNTA. Kedua fungsi tersebut bekerja sama, namun ada perbedaan besar yaitu Anda perlu mengetahui cara menggunakannya secara optimal.<\/p><ul><li> <strong>COUNT<\/strong> : Fungsi ini menghitung sel di mana Anda memiliki angka sebagai nilai di dalam sel. Misalnya, jika Anda memiliki 5 sel dalam rentang A1:A10 dengan nilai numerik, COUNT akan mengembalikan 5 pada hasilnya.<\/li><li> <strong>COUNTA<\/strong> : Fungsi ini menghitung sel di mana Anda memiliki nilai, artinya sel yang tidak kosong atau kosong. Misalnya, jika Anda memiliki 7 sel dalam rentang A1:A10 dengan nilai, hasilnya akan menghasilkan 7. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70604\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\" sizes=\"auto, \" srcset=\"\" alt=\"hitung-melawan-hitungan\" width=\"480\" height=\"331\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Contoh untuk memahami perbedaannya (COUNT Vs. COUNTA)<\/h2><p> Dalam contoh berikut, kita memiliki daftar nilai di kolom A di mana kita memiliki berbagai jenis nilai termasuk angka, teks, simbol, dan nilai kosong. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70605\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cellules-avec-des-valeurs-differentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"sel-dengan-nilai-berbeda\" width=\"330\" height=\"427\"><\/figure><\/div><p> Sekarang ketika Anda menggunakan fungsi COUNT, hasilnya akan kembali menjadi 3 karena Anda hanya memiliki tiga nilai dari 9 yang merupakan angka. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70606\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-la-formule-de-comptage.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan rumus penghitungan\" width=\"417\" height=\"403\"><\/figure><\/div><p> Tetapi ketika Anda menggunakan fungsi COUNTA untuk rentang yang sama, hasilnya akan kembali menjadi 9 karena kita memiliki 9 sel dengan nilai dalam rentang tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70607\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-la-formule-counta.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-counta-rumus\" width=\"381\" height=\"390\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Fungsi mana yang lebih baik di antara keduanya<\/h2><p> Kedua fungsi tersebut berguna dan mudah digunakan, namun, dalam skenario dunia nyata, COUNTA lebih masuk akal karena dapat membantu Anda menghitung sel dengan nilai yang lebih sering daripada menghitung sel dengan angka. Namun hal tersebut tidak membuat fungsi COUNT menjadi kurang berguna, orang yang menganalisis data sering menggunakan fungsi COUNT.<\/p><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-dengan-teks\/\">Hitung sel dengan teks di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-tertentu\/\">Hitung karakter tertentu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/\">Hitung jumlah total sel dalam suatu rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik-1\/\">Hitung nilai unik di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2047","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Apa perbedaan antara COUNT dan COUNTA di Excel?<\/title>\n<meta name=\"description\" content=\"Pada tutorial rumus ini, kita akan mempelajari perbedaan antara fungsi COUNT dan fungsi COUNTA yang kita miliki di Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apa perbedaan antara COUNT dan COUNTA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Pada tutorial rumus ini, kita akan mempelajari perbedaan antara fungsi COUNT dan fungsi COUNTA yang kita miliki di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\",\"name\":\"Apa perbedaan antara COUNT dan COUNTA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\",\"datePublished\":\"2023-10-23T00:01:03+00:00\",\"dateModified\":\"2023-12-06T06:12:46+00:00\",\"description\":\"Pada tutorial rumus ini, kita akan mempelajari perbedaan antara fungsi COUNT dan fungsi COUNTA yang kita miliki di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apa perbedaan antara count dan counta?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apa perbedaan antara COUNT dan COUNTA di Excel?","description":"Pada tutorial rumus ini, kita akan mempelajari perbedaan antara fungsi COUNT dan fungsi COUNTA yang kita miliki di Excel.","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:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/","og_locale":"id_ID","og_type":"article","og_title":"Apa perbedaan antara COUNT dan COUNTA di Excel?","og_description":"Pada tutorial rumus ini, kita akan mempelajari perbedaan antara fungsi COUNT dan fungsi COUNTA yang kita miliki di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/","name":"Apa perbedaan antara COUNT dan COUNTA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","datePublished":"2023-10-23T00:01:03+00:00","dateModified":"2023-12-06T06:12:46+00:00","description":"Pada tutorial rumus ini, kita akan mempelajari perbedaan antara fungsi COUNT dan fungsi COUNTA yang kita miliki di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Apa perbedaan antara count dan counta?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2047","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2047"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2047\/revisions"}],"predecessor-version":[{"id":2245,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2047\/revisions\/2245"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}