{"id":2875,"date":"2023-07-20T07:25:26","date_gmt":"2023-07-20T07:25:26","guid":{"rendered":"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/"},"modified":"2023-07-20T07:25:26","modified_gmt":"2023-07-20T07:25:26","slug":"countif-wildcard-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/","title":{"rendered":"Cara menggunakan countif dengan wildcard di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut di Google Sheets untuk menggunakan wildcard dengan fungsi COUNTIF:<\/span><\/p>\n

Formula 1: COUNTIF dengan Satu Wildcard<\/strong><\/span><\/p>\n

 =<\/span> COUNTIF<\/span> (<\/span> A2:A11<\/span> ,<\/span> \" *string*<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini menghitung jumlah sel dalam rentang A2:A11<\/strong> yang berisi “string” di mana pun di dalam sel.<\/span><\/p>\n
 Rumus 2: COUNTIF dengan banyak wildcard<\/strong><\/span><\/p>\n
 =COUNTIFS( A2:A11<\/span> , \" *string1*<\/span> \"<\/span> , B2:B11<\/span> , \" *string2*<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n
 Rumus khusus ini menghitung jumlah sel di mana A2:A11<\/strong> berisi “string1” dan B2:B11<\/strong> berisi “string2”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n
 Contoh 1: COUNTIF dengan wildcard<\/strong><\/span><\/h3>\n
 Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom A yang berisi “avs” di mana pun di sel:<\/span><\/p>\n
 =COUNTIF( A2:A11<\/span> , \" *avs*<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Dari hasilnya terlihat ada 5<\/strong> sel pada kolom A yang namanya mengandung \u201cavs\u201d.<\/span><\/p>\n
 Contoh 2: COUNTIF dengan beberapa wildcard<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk menghitung jumlah baris dimana A2:A11<\/strong> berisi “avs” dan B2:B11<\/strong> berisi “Gua”:<\/span><\/p>\n
 =<\/span> COUNTIFS<\/span> (<\/span> A2:A11<\/span> ,<\/span> \" *avs*<\/span> \"<\/span> ,<\/span> B2:B11<\/span> ,<\/span> \" *Gua*<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Dari hasilnya kita bisa melihat ada 2<\/strong> baris dimana team berisi “avs” dan position berisi “Gua” di suatu tempat di dalam sel.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menggunakan COUNTIF dengan OR di Google Sheets<\/a>
 Cara menggunakan COUNTIF dari sheet lain di Google Sheets<\/a>
 Cara menggunakan COUNTIFS dengan rentang tanggal di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut di Google Sheets untuk menggunakan wildcard dengan fungsi COUNTIF: Formula 1: COUNTIF dengan Satu Wildcard = COUNTIF ( A2:A11 , ” *string* ” ) Rumus khusus ini menghitung jumlah sel dalam rentang A2:A11 yang berisi “string” di mana pun di dalam sel. Rumus 2: COUNTIF dengan banyak wildcard =COUNTIFS( A2:A11 […]<\/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 wildcard di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan COUNTIF dengan wildcard di Google Sheets, beserta contohnya.\" \/>\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-wildcard-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 wildcard di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan COUNTIF dengan wildcard di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T07:25:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique11.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-wildcard-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/\",\"name\":\"Cara menggunakan COUNTIF dengan wildcard di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T07:25:26+00:00\",\"dateModified\":\"2023-07-20T07:25:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan COUNTIF dengan wildcard di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan countif dengan wildcard 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 wildcard di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan COUNTIF dengan wildcard di Google Sheets, beserta contohnya.","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-wildcard-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan COUNTIF dengan wildcard di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan COUNTIF dengan wildcard di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T07:25:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique11.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-wildcard-google-sheet\/","url":"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/","name":"Cara menggunakan COUNTIF dengan wildcard di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T07:25:26+00:00","dateModified":"2023-07-20T07:25:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan COUNTIF dengan wildcard di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/countif-wildcard-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan countif dengan wildcard 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\/2875"}],"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=2875"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2875\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}