{"id":2672,"date":"2023-07-21T06:02:39","date_gmt":"2023-07-21T06:02:39","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/"},"modified":"2023-07-21T06:02:39","modified_gmt":"2023-07-21T06:02:39","slug":"rata-rata-google-sheet-jika-tidak-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/","title":{"rendered":"Google sheets: cara menghitung rata-rata jika tidak kosong"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk menghitung nilai rata-rata suatu rentang di Google Spreadsheet hanya jika setiap sel dalam rentang tersebut tidak kosong:<\/span><\/p>\n

 =<\/span> IF<\/span> (<\/span> COUNT<\/span> (<\/span> A1:A10<\/span> )<\/span> ,<\/span> AVERAGE<\/span> ( A1:A10<\/span><\/span> )<\/span> ,<\/span> 0<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n
 Rumus ini menghitung nilai rata-rata sel dalam rentang A1:A10<\/strong> . Jika setiap nilai dalam rentang tersebut kosong, rumusnya akan mengembalikan 0<\/strong> .<\/span><\/p>\n
 Anda juga bisa menggunakan rumus berikut untuk mengembalikan ruang kosong:<\/span><\/p>\n
 =<\/span> IF<\/span> (<\/span> COUNT<\/span> (<\/span> A1:A10<\/span> )<\/span> ,<\/span> AVERAGE<\/span> ( A1:A10<\/span><\/span> )<\/span> ,<\/span> \"\")<\/span><\/strong><\/span>\n<\/pre>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh 1: rata-rata jika tidak kosong (mengembalikan nilai)<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung nilai rata-rata pada kolom B yang hanya sedikit nilai yang hilang:<\/span> <\/p>\n
\"\"<\/p>\n
 Karena hanya ada sedikit nilai yang hilang, rumusnya hanya mengembalikan rata-rata dari nilai yang tidak hilang.<\/span><\/span><\/p>\n
 Contoh 2: rata-rata jika tidak kosong (kembali ke nol)<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung nilai rata-rata di kolom B yang setiap nilainya tidak ada:<\/span> <\/p>\n
\"\"<\/p>\n
 Karena setiap nilai hilang di kolom B, rumusnya hanya mengembalikan nilai 0.<\/span><\/p>\n
 Contoh 3: Rata-rata jika tidak kosong (kembali kosong)<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung nilai rata-rata di kolom B yang setiap nilainya tidak ada:<\/span> <\/p>\n
\"\"<\/p>\n
 Karena setiap nilai hilang di kolom B, rumusnya hanya menghasilkan nilai kosong.<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
Google Sheets: cara menambahkan sel jika tidak kosong<\/a>
 Google Sheets: Cara mengganti sel kosong dengan nol<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut untuk menghitung nilai rata-rata suatu rentang di Google Spreadsheet hanya jika setiap sel dalam rentang tersebut tidak kosong: = IF ( COUNT ( A1:A10 ) , AVERAGE ( A1:A10 ) , 0 ) Rumus ini menghitung nilai rata-rata sel dalam rentang A1:A10 . Jika setiap nilai dalam rentang tersebut kosong, […]<\/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":"\nGoogle Sheets: Cara menghitung rata-rata jika tidak kosong - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata di Google Sheets jika rentang sel tidak kosong.\" \/>\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\/rata-rata-google-sheet-jika-tidak-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: Cara menghitung rata-rata jika tidak kosong - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata di Google Sheets jika rentang sel tidak kosong.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T06:02:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/blanc11.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\/rata-rata-google-sheet-jika-tidak-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/\",\"name\":\"Google Sheets: Cara menghitung rata-rata jika tidak kosong - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T06:02:39+00:00\",\"dateModified\":\"2023-07-21T06:02:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata di Google Sheets jika rentang sel tidak kosong.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara menghitung rata-rata jika tidak kosong\"}]},{\"@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 Sheets: Cara menghitung rata-rata jika tidak kosong - Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata di Google Sheets jika rentang sel tidak kosong.","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\/rata-rata-google-sheet-jika-tidak-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: Cara menghitung rata-rata jika tidak kosong - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata di Google Sheets jika rentang sel tidak kosong.","og_url":"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-21T06:02:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/blanc11.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\/rata-rata-google-sheet-jika-tidak-kosong\/","url":"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/","name":"Google Sheets: Cara menghitung rata-rata jika tidak kosong - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T06:02:39+00:00","dateModified":"2023-07-21T06:02:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata di Google Sheets jika rentang sel tidak kosong.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara menghitung rata-rata jika tidak kosong"}]},{"@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\/2672"}],"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=2672"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2672\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}