{"id":2378,"date":"2023-07-22T13:10:10","date_gmt":"2023-07-22T13:10:10","guid":{"rendered":"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/"},"modified":"2023-07-22T13:10:10","modified_gmt":"2023-07-22T13:10:10","slug":"countif-atau-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/","title":{"rendered":"Cara menggunakan countif dengan or di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Seringkali, Anda mungkin ingin menghitung jumlah sel dalam suatu rentang di Google Spreadsheet yang memenuhi salah satu dari beberapa kriteria.<\/span><\/p>\n

Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut:<\/span><\/p>\n

 =<\/span> ArrayFormula<\/span> (<\/span> SUM<\/span> (<\/span> COUNTIF<\/span> (<\/span> A:A<\/span> ,<\/span> {<\/span> \" Value1<\/span> \"<\/span> ,<\/span> \" Value2<\/span> \", \" Value3<\/span> \"<\/span> }<\/span> )<\/span> )<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini menghitung jumlah sel di kolom A yang sama dengan “Nilai1”, “Nilai2”, atau “Nilai3”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Gunakan COUNTIF dengan OR di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki data berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom A yang memiliki nilai “Timur” atau “Selatan”:<\/span><\/p>\n
 =<\/span> ArrayFormula<\/span> (<\/span> SUM<\/span> (<\/span> COUNTIF<\/span> (<\/span> A:A<\/span> ,<\/span> {<\/span> \" East<\/span> \"<\/span> ,<\/span> \" South<\/span> \"<\/span> }<\/span> )<\/span> )<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat melihat total 5<\/strong> sel memiliki nilai “Timur” atau “Selatan” di kolom A.<\/span><\/p>\n
 Kita juga bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom C yang memiliki nilai 95, 99, atau 103:<\/span><\/p>\n
 =<\/span> ArrayFormula<\/span> (<\/span> SUM<\/span> (<\/span> COUNTIF<\/span> (<\/span> C:<\/span> C<\/span> ,<\/span> {<\/span> 95,99,103<\/span><\/span> }<\/span> )<\/span> )<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat melihat total 6<\/strong> sel memiliki nilai 95, 99 atau 103 di kolom C.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi COUNTIF()<\/strong> umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a>
 Google Spreadsheet: Cara menggunakan COUNTIF dengan banyak rentang<\/a>
 Google Sheets: Cara menggunakan COUNTIFS dengan rentang tanggal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali, Anda mungkin ingin menghitung jumlah sel dalam suatu rentang di Google Spreadsheet yang memenuhi salah satu dari beberapa kriteria. Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut: = ArrayFormula ( SUM ( COUNTIF ( A:A , { ” Value1 ” , ” Value2 “, ” Value3 ” } ) ) ) Rumus khusus ini […]<\/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 menggunakan COUNTIF dengan OR di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF() dengan OR 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\/countif-atau-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan COUNTIF dengan OR di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF() dengan OR di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T13:10:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou1.png\" \/>\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\/countif-atau-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/\",\"name\":\"Cara menggunakan COUNTIF dengan OR di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T13:10:10+00:00\",\"dateModified\":\"2023-07-22T13:10:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF() dengan OR di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan countif dengan or 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 menggunakan COUNTIF dengan OR di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF() dengan OR 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\/countif-atau-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan COUNTIF dengan OR di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF() dengan OR di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T13:10:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou1.png"}],"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\/countif-atau-google-sheet\/","url":"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/","name":"Cara menggunakan COUNTIF dengan OR di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T13:10:10+00:00","dateModified":"2023-07-22T13:10:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF() dengan OR di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/countif-atau-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan countif dengan or 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\/2378"}],"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=2378"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2378\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}