{"id":2808,"date":"2023-07-20T14:53:45","date_gmt":"2023-07-20T14:53:45","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/"},"modified":"2023-07-20T14:53:45","modified_gmt":"2023-07-20T14:53:45","slug":"google-sheet-abaikan-na","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/","title":{"rendered":"Cara mengabaikan nilai #n\/a dengan rumus di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghitung metrik yang berbeda di Google Spreadsheet sambil mengabaikan nilai #N\/A:<\/span><\/p>\n

 =AVERAGE(IFNA( A2:A14<\/span> , \"\")) \n\n=SUM(IFNA( A2:A14<\/span> , \"\"))\n\n=IFNA(VLOOKUP( E2<\/span> , A2:A14<\/span> , 2<\/span> , FALSE<\/span> ), \"\")<\/strong><\/pre>\n
 Rumus ini cukup mengganti nilai #N\/A dengan nilai kosong, lalu menghitung metrik yang Anda minati.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh 1: Hitung rata-rata dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung rata-rata kumpulan data yang berisi nilai #N\/A:<\/span> <\/p>\n
\"\"<\/p>\n
 Nilai rata-rata kumpulan data (mengabaikan semua nilai #N\/A) adalah 9.7<\/strong> .<\/span><\/p>\n
 Contoh 2:<\/strong><\/span> Hitung jumlahnya dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung jumlah kumpulan data yang berisi nilai #N\/A:<\/span> <\/p>\n
\"\"<\/p>\n
 Jumlah seluruh kumpulan data (mengabaikan semua nilai #N\/A) adalah 97<\/strong> .<\/span><\/p>\n
 Contoh 3:<\/strong><\/span> Gunakan VLOOKUP dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut memperlihatkan cara menggunakan fungsi VLOOKUP<\/strong> untuk mengembalikan nilai di kolom Poin yang cocok dengan nilai di kolom Tim:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa untuk nilai apa pun di kolom Poin yang sama dengan #N\/A, fungsi VLOOKUP<\/strong> hanya mengembalikan nilai kosong, bukan nilai #N\/A.<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menghapus karakter khusus di Google Sheets<\/a>
 Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a>
 Cara menggunakan ISERROR di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghitung metrik yang berbeda di Google Spreadsheet sambil mengabaikan nilai #N\/A: =AVERAGE(IFNA( A2:A14 , “”)) =SUM(IFNA( A2:A14 , “”)) =IFNA(VLOOKUP( E2 , A2:A14 , 2 , FALSE ), “”) Rumus ini cukup mengganti nilai #N\/A dengan nilai kosong, lalu menghitung metrik yang Anda minati. Contoh berikut menunjukkan cara […]<\/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":"\nCara mengabaikan nilai #N\/A dengan rumus di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A 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-abaikan-na\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A saat menggunakan rumus di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:53:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nagoogle1.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-abaikan-na\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/\",\"name\":\"Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:53:45+00:00\",\"dateModified\":\"2023-07-20T14:53:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A saat menggunakan rumus di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengabaikan nilai #n\/a dengan rumus di google sheets\"}]},{\"@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":"Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A 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-abaikan-na\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A saat menggunakan rumus di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:53:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nagoogle1.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-abaikan-na\/","url":"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/","name":"Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:53:45+00:00","dateModified":"2023-07-20T14:53:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A saat menggunakan rumus di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengabaikan nilai #n\/a dengan rumus di google sheets"}]},{"@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\/2808"}],"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=2808"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2808\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}