{"id":1804,"date":"2023-11-03T20:12:00","date_gmt":"2023-11-03T20:12:00","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/"},"modified":"2023-12-06T06:15:41","modified_gmt":"2023-12-06T06:15:41","slug":"jumlah-jika-kosong-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/","title":{"rendered":"Bagaimana cara menambahkan sel kosong di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3500308669\"><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 menggunakan SUMIF untuk menjumlahkan nilai kriteria kosong, cukup tentukan nilai kosong dalam argumen kriteria ke fungsi SUMIF. Dengan ini, beri tahu Excel untuk hanya mempertimbangkan sel yang tidak memiliki nilai. Pada contoh di bawah, kita memiliki tiga sel kosong di kolom nama yang perlu kita jumlahkan jumlah donasinya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77799\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai sumif-untuk-kosong\" width=\"540\" height=\"519\"><\/figure><\/div><p> Dalam tutorial ini, kita akan mempelajari cara menggunakan fungsi SUMIF atau SUMIFS untuk menjumlahkan nilai kosong.<\/p><h2 class=\"wp-block-heading\"> Tulis rumus untuk menggunakan SUMIF untuk nilai kosong<\/h2><ol type=\"1\"><li> Pertama, masukkan SUMIF di sel tempat Anda ingin menghitung jumlahnya.<\/li><li> Sekarang lihat kolom Nama di mana Anda memiliki sel kosong.<\/li><li> Setelah itu masukkan tanda kutip ganda (awal dan penutup).<\/li><li> Selanjutnya, lihat kolom Donasi tempat Anda perlu menjumlahkan nilainya.<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77800\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-2-sumif-pour-les-valeurs-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-sumif-untuk-nilai-kosong\" width=\"632\" height=\"459\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">=SUMIF(A2:A13,\"\",B2:B13)<\/code><\/pre><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, namun bukan sel kosong.<\/p><p> Dalam hal ini, SUMIF akan mengabaikan sel ini dan tidak menyertakannya saat menghitung jumlahnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77801\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-ignore-les-cellules-vides-avec-espace.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-abaikan-sel-kosong-dengan-spasi\" width=\"441\" height=\"378\"><\/figure><\/div><p> Di sini Anda bisa membuat rumus menggunakan SUMIFS dan SUM untuk membuat SUMIF OR. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77802\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-somme-et-somme-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-dan-jumlah\" width=\"482\" height=\"368\"><\/figure><\/div><p> Dalam rumus ini, Anda harus menentukan dua kriteria dalam argumen kriteria1 menggunakan kurung kurawal.<\/p><ul><li> Ruang angkasa<\/li><li> Putih <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77803\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-espace-a-deux-criteres-et-blanc.png\" sizes=\"auto, \" srcset=\"\" alt=\"dua kriteria-spasi-dan-putih\" width=\"607\" height=\"102\"><\/figure><\/div><p> Saat Anda melakukan ini, SUMIF mempertimbangkan kedua kriteria secara bersamaan. Dan untuk mendapatkan hasilnya, Anda perlu memasukkannya sebagai rumus array (gunakan Ctrl + Alt + Enter).<\/p><p class=\"formula\"> =JUMLAH(SUMIFS(B2:B13,A2:A13,{\u201c\u201d,\u201d \u201c}))<\/p><p> Anda dapat mengetahui lebih lanjut <a href=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\">di sini<\/a> . <\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-si-vide.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/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\/jumlah-jika-berisi\/\">Jumlahkan JIKA sel berisi teks tertentu (SUMIF sebagian teks)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-tahun-2\/\">Jumlah nilai menurut tahun (SUMIF Tahun)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/\">SUMIF berdasarkan tanggal (jumlah nilai berdasarkan tanggal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-tidak-kosong-2\/\">SUMIF tidak kosong (nilai penjumlahan untuk sel yang tidak kosong)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kurang-dari\/\">Jumlah nilai yang kurang dari nilai tertentu (SUMIF kurang dari)<\/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-1804","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 menambahkan sel kosong di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menambahkan nilai berdasarkan sel kosong. Jika sel kosong, ini akan diambil\" \/>\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-jika-kosong-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan sel kosong di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menambahkan nilai berdasarkan sel kosong. Jika sel kosong, ini akan diambil\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan sel kosong di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\",\"datePublished\":\"2023-11-03T20:12:00+00:00\",\"dateModified\":\"2023-12-06T06:15:41+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menambahkan nilai berdasarkan sel kosong. Jika sel kosong, ini akan diambil\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan 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":"\u25b7 Bagaimana cara menambahkan sel kosong di Excel?","description":"Dalam tutorial ini, kita akan mempelajari cara menambahkan nilai berdasarkan sel kosong. Jika sel kosong, ini akan diambil","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-jika-kosong-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan sel kosong di Excel?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menambahkan nilai berdasarkan sel kosong. Jika sel kosong, ini akan diambil","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.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\/jumlah-jika-kosong-2\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/","name":"\u25b7 Bagaimana cara menambahkan sel kosong di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","datePublished":"2023-11-03T20:12:00+00:00","dateModified":"2023-12-06T06:15:41+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menambahkan nilai berdasarkan sel kosong. Jika sel kosong, ini akan diambil","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-kosong-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan 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\/1804","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=1804"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1804\/revisions"}],"predecessor-version":[{"id":2440,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1804\/revisions\/2440"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}