{"id":1695,"date":"2023-11-11T10:48:33","date_gmt":"2023-11-11T10:48:33","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/"},"modified":"2023-12-06T06:20:48","modified_gmt":"2023-12-06T06:20:48","slug":"rata-rata-sel-yang-tidak-kosong-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/","title":{"rendered":"Rata-rata hanya sel yang tidak kosong di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-821354000\"><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 rata-rata hanya sel yang tidak kosong di Excel, Anda perlu menggunakan fungsi AVERAGEIF. Dan dalam kriteria Anda perlu menggunakan operator <a href=\"https:\/\/exceladvisor.org\/id\/tidak-sama\/\">tidak sama<\/a> untuk merujuk hanya ke sel yang tidak kosong. Dalam tutorial ini, kita akan melihat rumus ini secara mendalam.<\/p><h2 class=\"wp-block-heading\"> Rata-rata hanya sel yang tidak kosong<\/h2><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Pertama, di sel C1, masukkan fungsi AVERAGEIF.<\/li><li> Setelah itu, pada argumen pertama (rentang), lihat rentang A1:A9.<\/li><li> Sekarang pada argumen kedua, enter tidak sama dengan operator yang menggunakan tanda kutip ganda.<\/li><li> Terakhir, masukkan tanda kurung penutup dan 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-79245\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"rata-rata-untuk-sel yang tidak kosong\" width=\"484\" height=\"525\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGEIF(A1:A9,\"&lt;&gt;\")<\/code><\/pre><p> Saat Anda menggunakannya, AVERAGEIF hanya mempertimbangkan sel yang tidak kosong dan hanya membuat rata-rata sel tersebut. Anda dapat melihat bahwa ketika saya memilih sel di mana kita memiliki nilai, rata-rata yang sama ditampilkan di <a href=\"https:\/\/exceladvisor.org\/id\/status-bar\/\">bilah status<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79246\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-resultat-moyen-pour-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil-rata-rata-untuk-sel yang tidak kosong\" width=\"589\" height=\"324\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Masalah yang mungkin Anda hadapi<\/h2><p> Mungkin saja Anda memiliki sel kosong dalam rentang tersebut dan sel kosong tersebut memiliki ruang yang tidak terlihat. Dalam hal ini, rumus Anda tidak akan menganggap sel ini sebagai sel kosong dan akan menghitung rata-rata dengan menyertakannya juga.<\/p><p> Nah, Anda bisa menggunakan rumus di bawah ini dimana kita telah menggunakan AVERAGEIF untuk menentukan dua kriteria, satu adalah memasukkan sel yang tidak kosong dan yang lainnya adalah mengabaikan sel yang memiliki spasi.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGEIFS(A1:A9,A1:A9,\"&lt;&gt;\",A1:A9,\"&lt;&gt;\"&amp;\" \")<\/code><\/pre><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\/moyenne-des-cellules-non-vides.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\/nilai-maksimum-rata-rata\/\">Rata-rata dari 5 nilai tertinggi di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-tertimbang\/\">Hitung rata-rata tertimbang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-kesalahan-yang-diabaikan-2\/\">Rata-rata tetapi mengabaikan kesalahan (#N\/A dan kesalahan lainnya)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-tidak-termasuk-angka-nol-2\/\">Angka rata-rata tetapi tidak termasuk angka nol<\/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-1695","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>Rata-rata hanya sel yang tidak kosong di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung rata-rata hanya sel yang tidak kosong. Mari kita periksa ini\u2026\" \/>\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\/rata-rata-sel-yang-tidak-kosong-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rata-rata hanya sel yang tidak kosong di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung rata-rata hanya sel yang tidak kosong. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-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\/rata-rata-sel-yang-tidak-kosong-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/\",\"name\":\"Rata-rata hanya sel yang tidak kosong di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\",\"datePublished\":\"2023-11-11T10:48:33+00:00\",\"dateModified\":\"2023-12-06T06:20:48+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung rata-rata hanya sel yang tidak kosong. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rata-rata hanya sel yang tidak 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":"Rata-rata hanya sel yang tidak kosong di Excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung rata-rata hanya sel yang tidak kosong. Mari kita periksa ini\u2026","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\/rata-rata-sel-yang-tidak-kosong-2\/","og_locale":"id_ID","og_type":"article","og_title":"Rata-rata hanya sel yang tidak kosong di Excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung rata-rata hanya sel yang tidak kosong. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:48+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-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\/rata-rata-sel-yang-tidak-kosong-2\/","url":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/","name":"Rata-rata hanya sel yang tidak kosong di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png","datePublished":"2023-11-11T10:48:33+00:00","dateModified":"2023-12-06T06:20:48+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menghitung rata-rata hanya sel yang tidak kosong. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/rata-rata-sel-yang-tidak-kosong-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Rata-rata hanya sel yang tidak 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\/1695","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=1695"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1695\/revisions"}],"predecessor-version":[{"id":2942,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1695\/revisions\/2942"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}