{"id":3712,"date":"2023-07-16T00:07:30","date_gmt":"2023-07-16T00:07:30","guid":{"rendered":"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/"},"modified":"2023-07-16T00:07:30","modified_gmt":"2023-07-16T00:07:30","slug":"countif-berisi-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/","title":{"rendered":"Cara menggunakan countif terdapat di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk menghitung jumlah sel yang berisi string tertentu:<\/span><\/p>\n

Metode 1: COUNTIF berisi (kriteria)<\/strong><\/span><\/p>\n

 = COUNTIF<\/span><\/span> (<\/span> A2:A11<\/span> ,<\/span> \" *string*<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus ini menghitung jumlah sel di A2:A11<\/strong> yang berisi “string” di mana saja di dalam sel.<\/span><\/p>\n
 Metode 2: COUNTIF berisi (beberapa kriteria)<\/strong><\/span><\/p>\n
 = COUNTIFS<\/span><\/span> (<\/span> A2:A11<\/span> ,<\/span> \" *string1*<\/span> \"<\/span> ,<\/span> B2:B11<\/span> ,<\/span> \" *string2*<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n
 Rumus ini menghitung jumlah baris dimana sel dalam rentang A2:A11<\/strong> berisi “string1” dan sel dalam rentang B2:B11<\/strong> berisi “string2”.<\/span><\/p>\n
 Catatan<\/strong> : Operator *<\/strong> adalah karakter pengganti di Google Spreadsheet.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n
 Contoh 1: COUNTIF berisi (kriteria)<\/strong><\/span><\/h2>\n
 Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom Tim<\/strong> yang berisi string “Mav”:<\/span><\/p>\n
 =<\/span> COUNTIF<\/span> (<\/span> A2:A11<\/span> ,<\/span> \" *Mav*<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Dari hasilnya, kita dapat melihat bahwa 5 baris di kolom Tim berisi \u201cMav\u201d di suatu tempat di selnya.<\/span><\/p>\n
 Contoh 2: COUNTIF berisi (beberapa kriteria)<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan rumus berikut untuk menghitung jumlah baris dimana kolom Tim<\/strong> berisi “Mav” dan kolom Posisi<\/strong> berisi “Guar”:<\/span><\/p>\n
 = COUNTIFS<\/span><\/span> (<\/span> A2:A11<\/span> ,<\/span> \" *Mav*<\/span> \"<\/span> ,<\/span> B2:B11<\/span> ,<\/span> \" *Guar*<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Dari hasilnya terlihat 2 baris berisi “Mav” pada kolom Tim<\/strong> dan “Guar” pada kolom Posisi<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: COUNTIF lebih besar dari nol<\/a>
 Google Spreadsheet: Cara menggunakan COUNTIF dengan OR<\/a>
 Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk menghitung jumlah sel yang berisi string tertentu: Metode 1: COUNTIF berisi (kriteria) = COUNTIF ( A2:A11 , ” *string* ” ) Rumus ini menghitung jumlah sel di A2:A11 yang berisi “string” di mana saja di dalam sel. Metode 2: COUNTIF berisi (beberapa kriteria) = COUNTIFS ( […]<\/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 yang ada di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan COUNTIF yang berisi 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-berisi-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan COUNTIF yang ada di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan COUNTIF yang berisi di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T00:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombreif1.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\/countif-berisi-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/\",\"name\":\"Cara menggunakan COUNTIF yang ada di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T00:07:30+00:00\",\"dateModified\":\"2023-07-16T00:07:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan COUNTIF yang berisi di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan countif terdapat 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 yang ada di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan COUNTIF yang berisi 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-berisi-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan COUNTIF yang ada di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan COUNTIF yang berisi di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-16T00:07:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombreif1.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\/countif-berisi-lembar-google\/","url":"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/","name":"Cara menggunakan COUNTIF yang ada di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T00:07:30+00:00","dateModified":"2023-07-16T00:07:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan COUNTIF yang berisi di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/countif-berisi-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan countif terdapat 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\/3712"}],"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=3712"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3712\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}