{"id":1556,"date":"2023-11-17T07:33:43","date_gmt":"2023-11-17T07:33:43","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/"},"modified":"2023-12-06T06:17:57","modified_gmt":"2023-12-06T06:17:57","slug":"jumlah-sel-kosong","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/","title":{"rendered":"Bagaimana cara menghitung sel kosong di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2821805411\"><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>Jika Anda ingin menghitung sel kosong di Excel, Anda bisa menggunakan fungsi COUNTBLANK yang dirancang khusus untuk menghitung sel kosong (tanpa nilai apa pun). Dalam fungsi COUNTBLANK, Anda hanya perlu merujuk pada rentang sel kosong yang ingin Anda hitung.<\/p><h2 class=\"wp-block-heading\"> Gunakan fungsi COUNTBLANK<\/h2><p> Dalam contoh berikut, Anda memiliki beberapa nilai dalam rentang A1:A10, namun beberapa sel kosong. Dan sekarang Anda perlu menghitung sel yang tidak mengandung nilai apa pun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67105\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"pantai-dengan-sel-kosong\" width=\"354\" height=\"315\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah berikut untuk menulis rumus ini:<\/p><ol><li> Pertama, di sel B1, mulailah mengetik fungsi COUNTBLANK (=COUNTBLANK).<\/li><li> Setelah itu, ketikkan tanda kurung awal.<\/li><li> Sekarang lihat rentang A1:A10 dalam fungsinya.<\/li><li> Terakhir, ketikkan tanda kurung tutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67106\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-a-2-chiffres.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus hitung kosong\" width=\"410\" height=\"314\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTBLANK(A1:A10)<\/code><\/pre><p> Setelah Anda menekan Enter, ini mengembalikan jumlah sel kosong dalam rentang yang ditentukan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67107\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeur-de-resultat-a-blanc.png\" sizes=\"auto, \" srcset=\"\" alt=\"countblank-hasil-nilai\" width=\"424\" height=\"320\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan COUNTIF untuk menghitung sel kosong<\/h2><p> Anda juga dapat menggunakan COUNTIF dan membuat kondisi untuk menghitung sel kosong. Dengan menggunakan contoh yang sama, Anda dapat mengikuti langkah-langkah di bawah ini untuk menulis rumus ini:<\/p><ol type=\"1\"><li> Pertama, di sel B1, mulailah mengetik fungsi COUNTIF (=COUNTIF) dan masukkan tanda kurung awal.<\/li><li> Sekarang lihat rentang A1:A10 tempat Anda ingin menghitung sel tanpa nilai.<\/li><li> Kemudian, pada argumen kriteria, ketik \u201c=\u201d. Operator sama dengan ini memberitahu Excel untuk menghitung sel di mana Anda tidak memiliki nilai karena dengan operator = Anda belum menentukan apa pun.<\/li><li> Setelah itu ketikkan tanda kurung tutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67108\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-countif-pour-compter-les-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung-untuk-menghitung-sel kosong\" width=\"436\" height=\"312\"><\/figure><\/div><p> Dan saat Anda menekan enter, ini mengembalikan jumlah sel kosong. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67109\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-comptes-pour-les-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung sel kosong\" width=\"466\" height=\"328\"><\/figure><\/div><p> Anda juga bisa menggunakan rumus seperti ini dengan kriteria \u201c=\u201d&amp;\u201d\u201d. Saat Anda menggunakannya, ini juga memberitahu Excel untuk hanya menghitung sel tanpa nilai. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67110\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-criteres-de-comptage-pour-les-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-kriteria-untuk-sel kosong\" width=\"478\" height=\"321\"><\/figure><\/div><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\/countif-cellules-vides-2.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\/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><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-yang-tidak-kosong\/\">Hitung sel yang tidak kosong di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/akun-lebih-besar-dari-nol\/\">Hitung lebih besar dari 0 (COUNTIF) di Excel<\/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-1556","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>Bagaimana cara menghitung sel kosong di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung sel kosong di Excel menggunakan berbagai rumus yang mudah digunakan.\" \/>\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\/jumlah-sel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghitung sel kosong di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung sel kosong di Excel menggunakan berbagai rumus yang mudah digunakan.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-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\/jumlah-sel-kosong\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/\",\"name\":\"Bagaimana cara menghitung sel kosong di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\",\"datePublished\":\"2023-11-17T07:33:43+00:00\",\"dateModified\":\"2023-12-06T06:17:57+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung sel kosong di Excel menggunakan berbagai rumus yang mudah digunakan.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung sel kosong di excel?\"}]},{\"@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":"Bagaimana cara menghitung sel kosong di Excel? - Penasihat Excel","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung sel kosong di Excel menggunakan berbagai rumus yang mudah digunakan.","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\/jumlah-sel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghitung sel kosong di Excel? - Penasihat Excel","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung sel kosong di Excel menggunakan berbagai rumus yang mudah digunakan.","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:57+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-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\/jumlah-sel-kosong\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/","name":"Bagaimana cara menghitung sel kosong di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png","datePublished":"2023-11-17T07:33:43+00:00","dateModified":"2023-12-06T06:17:57+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung sel kosong di Excel menggunakan berbagai rumus yang mudah digunakan.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-sel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung sel kosong di excel?"}]},{"@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\/1556","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=1556"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1556\/revisions"}],"predecessor-version":[{"id":2664,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1556\/revisions\/2664"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}