{"id":2841,"date":"2023-07-20T11:18:42","date_gmt":"2023-07-20T11:18:42","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/"},"modified":"2023-07-20T11:18:42","modified_gmt":"2023-07-20T11:18:42","slug":"google-sheet-mengabaikan-sel-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/","title":{"rendered":"Google sheets: cara mengabaikan sel kosong dengan rumus"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk mengabaikan nilai kosong selama penghitungan:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: hitung rata-ratanya dan abaikan bagian yang kosong<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGEIF( <span dir=\"auto\" style=\"color: #ff6600;\">A2:A13<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">&lt;&gt;<\/span> \"<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2:B13<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung nilai rata-rata dalam rentang <strong>B2:B13<\/strong> hanya untuk sel yang <strong>A2:A13<\/strong> tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Hitung jumlahnya dan abaikan bagian yang kosong<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=SUMIF( <span dir=\"auto\" style=\"color: #ff6600;\">A2:A13<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">&lt;&gt;<\/span> \"<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2:B13<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung jumlah nilai dalam rentang <strong>B2:B13<\/strong> hanya untuk sel yang <strong>A2:A13<\/strong> tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung rata-rata dan abaikan bagian yang kosong<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung nilai rata-rata di kolom <strong>Poin<\/strong> hanya untuk sel yang nilai di kolom <strong>Tim<\/strong> tidak kosong:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24887 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank1-1.jpg\" alt=\"\" width=\"574\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata poin untuk tim yang tidak mencetak gol adalah <strong>16,25<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan menghitung secara manual nilai poin rata-rata untuk tim yang tidak kosong:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poin rata-rata untuk tim non-perawan: (14+19+15+5+12+14+32+19) \/ 8 = <strong>16,25<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung jumlahnya dan abaikan bagian yang kosong<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung jumlah nilai kolom <strong>Poin<\/strong> hanya untuk sel yang nilai kolom <strong>Timnya<\/strong> tidak kosong:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24888 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank2.jpg\" alt=\"\" width=\"570\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah nilai poin untuk tim yang tidak mencetak gol adalah <strong>130<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan menghitung secara manual jumlah nilai poin untuk tim yang tidak kosong:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin untuk tim non-perawan: 14+19+15+5+12+14+32+19 = <strong>130<\/strong> .<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/google-sheet-sumif-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara menambahkan sel jika tidak kosong<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara mengganti sel kosong dengan nol<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk mengabaikan nilai kosong selama penghitungan: Rumus 1: hitung rata-ratanya dan abaikan bagian yang kosong =AVERAGEIF( A2:A13 , &#8221; &lt;&gt; &#8221; , B2:B13 ) Rumus ini menghitung nilai rata-rata dalam rentang B2:B13 hanya untuk sel yang A2:A13 tidak kosong. Rumus 2: Hitung jumlahnya dan abaikan bagian yang [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Spreadsheet: Cara mengabaikan sel kosong dengan rumus - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan sel kosong saat menggunakan rumus di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengabaikan sel kosong dengan rumus - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan sel kosong saat menggunakan rumus di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T11:18:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank1-1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\",\"name\":\"Google Spreadsheet: Cara mengabaikan sel kosong dengan rumus - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T11:18:42+00:00\",\"dateModified\":\"2023-07-20T11:18:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan sel kosong saat menggunakan rumus di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengabaikan sel kosong dengan rumus\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Spreadsheet: Cara mengabaikan sel kosong dengan rumus - Statorial","description":"Tutorial ini menjelaskan cara mengabaikan sel kosong saat menggunakan rumus di Google Sheets, dengan beberapa contoh.","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:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengabaikan sel kosong dengan rumus - Statorial","og_description":"Tutorial ini menjelaskan cara mengabaikan sel kosong saat menggunakan rumus di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-20T11:18:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorerblank1-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/","name":"Google Spreadsheet: Cara mengabaikan sel kosong dengan rumus - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T11:18:42+00:00","dateModified":"2023-07-20T11:18:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan sel kosong saat menggunakan rumus di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengabaikan sel kosong dengan rumus"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2841"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2841"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2841\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}