{"id":1558,"date":"2023-11-17T07:02:42","date_gmt":"2023-11-17T07:02:42","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/"},"modified":"2023-12-06T06:17:43","modified_gmt":"2023-12-06T06:17:43","slug":"menghitung-jumlah-sel-seluruhnya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/","title":{"rendered":"Bagaimana cara menghitung jumlah total sel dalam suatu rentang?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3339982569\"><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, Anda bisa menggunakan dua rumus berbeda jika Anda ingin menghitung jumlah sel dalam suatu rentang (sel kosong dan tidak kosong). Dalam tutorial ini, kita akan melihat kedua rumus tersebut.<\/p><h2 class=\"wp-block-heading\"> Hitung jumlah sel (Metode-1)<\/h2><p> Dalam contoh berikut, kami memiliki beberapa nilai di kolom A dan Anda perlu menghitung sel dalam rentang A1:B10. Dan untuk ini, kita akan menggunakan fungsi ROWS dan COLUMNS.<\/p><p> Langkah-langkah menuliskan rumusnya:<\/p><ol type=\"1\"><li> Pertama, di sel D1, masukkan \u201c <code>=ROWS (A1:B10)<\/code> \u201d.<\/li><li> Kemudian ketikkan tanda asterisk (*) untuk mengalikan nilainya.<\/li><li> Setelah itu, Anda perlu memasukkan fungsi COLUMN yang mengacu pada rentang yang sama (COLUMNS(A1:B10).<\/li><li> Terakhir, tekan tombol Enter untuk menampilkan hasilnya di sel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66794\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi baris dan kolom\" width=\"445\" height=\"273\"><\/figure><\/div><p> Sekarang seperti yang Anda lihat, ketika Anda menekan Enter, hasilnya akan kembali menjadi 20 karena Anda memiliki total 20 sel dalam rentang yang Anda tentukan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66795\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Resultat-de-comptage-de-2-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil jumlah sel\" width=\"496\" height=\"303\"><\/figure><\/div><p> Sekarang mari kita coba memahami rumus yang kita gunakan di sini. Pada bagian pertama, kami menggunakan fungsi ROWS yang mengembalikan jumlah baris yang Anda miliki dalam suatu rentang. Di sini ia mengembalikan 10 karena Anda memiliki sepuluh baris dalam rentang A1 hingga B10. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66796\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-3-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus garis\" width=\"471\" height=\"332\"><\/figure><\/div><p> Sekarang lain kali Anda memiliki fungsi COLUMNS yang mengembalikan jumlah kolom yang Anda miliki dalam suatu rentang. Di sini ia mengembalikan 2 karena Anda memiliki dua kolom dalam rentang A1 hingga B10. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66797\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-4-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom rumus\" width=\"421\" height=\"286\"><\/figure><\/div><p> Pada akhirnya Anda memiliki tanda bintang di antara dua nilai untuk mengalikan baris dan kolom guna mendapatkan jumlah total sel dalam rentang tersebut.<\/p><h2 class=\"wp-block-heading\"> Menggabungkan COUNTA \u2013 COUNTBLANK untuk menghitung sel dalam suatu rentang<\/h2><p> Cara kedua mengharuskan Anda menggabungkan fungsi COUNTA dan COUNTBLANK. Dengan menggabungkan kedua fungsi tersebut, Anda dapat menghitung semua sel yang tidak kosong dan semua sel kosong dalam suatu rentang. Di bawah ini kami memiliki contoh yang sama dengan yang kami gunakan pada contoh pertama.<\/p><p> Di sel D1, Anda bisa memasukkan rumus berikut: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTA(A1:B10)+COUNTBLANK(A1:B10)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66798\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-counta-countblank-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus counta-countblank\" width=\"546\" height=\"280\"><\/figure><\/div><p> Seperti yang saya katakan, rumus ini bekerja dalam dua bagian:<\/p><ol type=\"1\"><li> Fungsi COUNTA menghitung sel di mana Anda memiliki nilai.<\/li><li> Fungsi COUNTBLANK menghitung sel yang tidak memiliki nilai.<\/li><\/ol><p> Pada akhirnya, Anda memiliki &#8220;tanda +&#8221; yang menambahkan dua angka dan mengembalikan jumlah total sel yang Anda miliki dalam rentang yang Anda tentukan. <\/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\/compter-les-cellules-dune-plage.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-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-nilai-unik-1\/\">Hitung nilai unik di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\">COUNT Vs.COUNTA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-kata-katanya\/\">Hitung kata 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-1558","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 jumlah total sel dalam suatu rentang?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung jumlah total sel dalam suatu rentang di Excel menggunakan\" \/>\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-jumlah-sel-seluruhnya\/\" \/>\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 jumlah total sel dalam suatu rentang?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung jumlah total sel dalam suatu rentang di Excel menggunakan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.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-jumlah-sel-seluruhnya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/\",\"name\":\"\u25b7 Bagaimana cara menghitung jumlah total sel dalam suatu rentang?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\",\"datePublished\":\"2023-11-17T07:02:42+00:00\",\"dateModified\":\"2023-12-06T06:17:43+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung jumlah total sel dalam suatu rentang di Excel menggunakan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung jumlah total sel dalam suatu rentang?\"}]},{\"@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 jumlah total sel dalam suatu rentang?","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung jumlah total sel dalam suatu rentang di Excel menggunakan","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-jumlah-sel-seluruhnya\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghitung jumlah total sel dalam suatu rentang?","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung jumlah total sel dalam suatu rentang di Excel menggunakan","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:43+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.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-jumlah-sel-seluruhnya\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/","name":"\u25b7 Bagaimana cara menghitung jumlah total sel dalam suatu rentang?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","datePublished":"2023-11-17T07:02:42+00:00","dateModified":"2023-12-06T06:17:43+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menghitung jumlah total sel dalam suatu rentang di Excel menggunakan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung jumlah total sel dalam suatu rentang?"}]},{"@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\/1558","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=1558"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1558\/revisions"}],"predecessor-version":[{"id":2635,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1558\/revisions\/2635"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}