{"id":1788,"date":"2023-11-05T01:25:09","date_gmt":"2023-11-05T01:25:09","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/"},"modified":"2023-12-06T06:17:59","modified_gmt":"2023-12-06T06:17:59","slug":"menghitung-sel-yang-tidak-kosong","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/","title":{"rendered":"Bagaimana cara menghitung sel yang tidak kosong?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-119220245\"><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>Untuk menghitung sel yang tidak kosong, di Excel Anda bisa menggunakan fungsi COUNTIF atau COUNTIFS tergantung pada data yang Anda miliki di lembar kerja Anda. Anda perlu menentukan rentang dan kemudian operator yang tidak sama dengan dengan nilai kosong untuk mendapatkan jumlah sel yang tidak kosong (kosong).<\/p><p> Dalam tutorial ini, kita akan melihat dua cara berbeda untuk melakukan ini.<\/p><h2 class=\"wp-block-heading\"> COUNTIF tidak kosong (sel tidak kosong)<\/h2><p> Dalam contoh berikut kita memiliki rentang (A1:A10) di mana kita memiliki beberapa sel kosong. Tapi sekarang kita perlu menghitung semua sel yang tidak kosong dalam rentang ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67123\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang sel dengan sel kosong\" width=\"293\" height=\"317\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah berikut untuk menulis rumus:<\/p><ol type=\"1\"><li> Pertama, ketik <strong>=COUNTIF(<\/strong> di sel B1 untuk mulai mengetikkan fungsi di sel yang Anda inginkan hasilnya.<\/li><li> Setelah itu, pada argumen pertama, lihat rentang A1:A10. Ini adalah rentang di mana Anda ingin menghitung sel yang tidak kosong.<\/li><li> Kemudian, di argumen kedua, masukkan \u201c&lt;&gt;\u201d. Ini adalah operator tidak sama dengan yang memberitahu Excel untuk menghitung sel yang tidak kosong.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk melihat hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67124\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-countif-avec-operateur-non-egal.png\" sizes=\"auto, \" srcset=\"\" alt=\"countif-dengan-operator yang tidak setara\" width=\"405\" height=\"292\"><\/figure><\/div><p> Saat Anda menekan Enter, Anda mendapatkan jumlah sel yang tidak kosong. Dalam contoh kita, kita memiliki 6 sel yang tidak kosong dalam rentang tersebut.<\/p><p> Namun selain itu Anda juga bisa menggunakan rumus yang mana Anda bisa menggunakan operator yang sama dan menggabungkannya dengan nilai kosong. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIF(A1:A10,\"&lt;&gt;\"&amp;\"\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67125\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-countif-avec-un-resultat-doperateur-non-egal.png\" sizes=\"auto, \" srcset=\"\" alt=\"countif-dengan-hasil-operator-tidak-sama\" width=\"483\" height=\"298\"><\/figure><\/div><h2 class=\"wp-block-heading\"> COUNTA untuk menghitung sel yang tidak kosong<\/h2><p> Di Excel Anda bisa menggunakan COUNTA (yang bisa Anda gunakan untuk sejumlah sel tertentu dalam rentang yang tidak kosong). Pada contoh berikut kami menggunakan rentang yang sama, A1:A10, namun di sini kami menggunakan fungsi COUNTA. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67126\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-counta-pour-compter-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung-untuk-menghitung-sel yang tidak kosong\" width=\"454\" height=\"283\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Masalah yang mungkin Anda hadapi<\/h2><p> Mungkin ada situasi di mana Anda memiliki rentang sel di mana Anda memiliki satu sel atau beberapa sel dengan spasi sebagai nilai dalam sel yang terlihat seperti sel kosong. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67127\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Plage-de-5-cellules-avec-un-espace-comme-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang sel dengan spasi sebagai nilai\" width=\"365\" height=\"291\"><\/figure><\/div><p> Pada contoh di atas, kita memiliki daftar nilai yang sama lagi. Jika Anda perhatikan lebih dekat, Anda dapat melihat bahwa kami memiliki 6 sel yang tidak kosong tetapi hasilnya kami memiliki 7 sel di ketiga metode.<\/p><p> Alasannya adalah di sel A3 kita mempunyai ruang di dalam sel yang membuat sel tersebut tidak kosong. Sekarang solusi dari permasalahan ini adalah dengan menggunakan COUNTIFS. Seperti contoh berikut ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTIFS(A1:A10,\"&lt;&gt;\"&amp;\"\",A1:A10,\"&lt;&gt;\"&amp;\" \")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67128\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-6-comtes.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus hitungan\" width=\"473\" height=\"289\"><\/figure><\/div><p> Di sini, dengan menggunakan fungsi COUNTIFS, kita telah membuat dua kriteria yang memberitahu Excel untuk menghitung sel yang tidak kosong dan bebas spasi. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compte-si-non-vide.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><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-antara-dua-angka\/\">Hitung antara dua angka (COUNTIFS) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/\">Hitung sel kosong (blank) menggunakan COUNTIF di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hitung-jika-kurang-dari\/\">Hitung sel yang kurang dari nilai tertentu (COUNTIF) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-tidak-sama-dengan\/\">Hitung sel yang tidak sama dengan di Excel (COUNTIF)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1788","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>\u25b7 Bagaimana cara menghitung sel yang tidak kosong?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus\" \/>\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-sel-yang-tidak-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menghitung sel yang tidak kosong?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/\",\"name\":\"\u25b7 Bagaimana cara menghitung sel yang tidak kosong?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png\",\"datePublished\":\"2023-11-05T01:25:09+00:00\",\"dateModified\":\"2023-12-06T06:17:59+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung sel yang tidak kosong?\"}]},{\"@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":"\u25b7 Bagaimana cara menghitung sel yang tidak kosong?","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus","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-sel-yang-tidak-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghitung sel yang tidak kosong?","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/","name":"\u25b7 Bagaimana cara menghitung sel yang tidak kosong?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png","datePublished":"2023-11-05T01:25:09+00:00","dateModified":"2023-12-06T06:17:59+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung karakter tertentu di Excel menggunakan rumus","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules-avec-des-cellules-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung sel yang tidak kosong?"}]},{"@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\/1788","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=1788"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1788\/revisions"}],"predecessor-version":[{"id":2668,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1788\/revisions\/2668"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}