{"id":4705,"date":"2023-07-08T18:55:57","date_gmt":"2023-07-08T18:55:57","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-countif-joker\/"},"modified":"2023-07-08T18:55:57","modified_gmt":"2023-07-08T18:55:57","slug":"excel-countif-joker","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-countif-joker\/","title":{"rendered":"Cara menggunakan countif dengan wildcard di excel"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut di Excel untuk menggunakan wildcard dengan fungsi COUNTIF<\/strong> :<\/span><\/p>\n

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

 =<\/span> COUNTIF<\/span> (<\/span> A2:A11<\/span> ,<\/span> \"*string*\"<\/span> )<\/span>\n<\/strong><\/span><\/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: COUNTIFS dengan banyak karakter pengganti<\/strong><\/span><\/p>\n
 =COUNTIFS( A2:A11<\/span> , \"*string1*\"<\/span> , B2:B11<\/span> , \"*string2*\"<\/span> )\n<\/span><\/strong><\/span><\/pre>\n
 Rumus khusus ini menghitung jumlah sel di mana A2:A11<\/strong> berisi “string1” dan<\/em> 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><\/h2>\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> )\n<\/span><\/strong><\/span><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Excel<\/p>\n
 Dari hasilnya terlihat ada 6<\/b> sel pada kolom A yang berisi \u201cavs\u201d pada nama tim.<\/span><\/p>\n
 Contoh 2: COUNTIFS dengan banyak karakter pengganti<\/strong><\/span><\/h2>\n
 Kita dapat menggunakan rumus berikut untuk menghitung jumlah baris dimana A2:A11<\/strong> berisi “avs” dan<\/em> B2:B11<\/strong> berisi “gua”:<\/span><\/p>\n
 =<\/span> COUNTIFS<\/span> (<\/span> A2:A11<\/span> ,<\/span> \"*avs*\"<\/span> ,<\/span> B2:B11<\/span> ,<\/span> \"*gua*\"<\/span> )<\/span><\/strong><\/span><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Dari hasilnya kita bisa melihat ada 4<\/b> baris dimana team berisi “avs” dan position berisi “gua” di suatu tempat di dalam sel.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: Bagaimana COUNTIF tidak sama dengan teks<\/a>
 Excel: Cara COUNTIF lebih besar dari nol<\/a>
 Excel: cara menggunakan COUNTIF dengan beberapa kriteria dalam satu kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut di Excel 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: COUNTIFS dengan banyak karakter pengganti =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 Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan wildcard pada fungsi COUNTIF di Excel, 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\/excel-countif-joker\/\" \/>\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 Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan wildcard pada fungsi COUNTIF di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-countif-joker\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T18:55:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cwild2.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\/excel-countif-joker\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-countif-joker\/\",\"name\":\"Cara menggunakan COUNTIF dengan wildcard di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T18:55:57+00:00\",\"dateModified\":\"2023-07-08T18:55:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan wildcard pada fungsi COUNTIF di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-countif-joker\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-countif-joker\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-countif-joker\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan countif dengan wildcard di excel\"}]},{\"@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 Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan wildcard pada fungsi COUNTIF di Excel, 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\/excel-countif-joker\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan COUNTIF dengan wildcard di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan wildcard pada fungsi COUNTIF di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-countif-joker\/","og_site_name":"Statorials","article_published_time":"2023-07-08T18:55:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cwild2.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\/excel-countif-joker\/","url":"https:\/\/statorials.org\/id\/excel-countif-joker\/","name":"Cara menggunakan COUNTIF dengan wildcard di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T18:55:57+00:00","dateModified":"2023-07-08T18:55:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan wildcard pada fungsi COUNTIF di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-countif-joker\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-countif-joker\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-countif-joker\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan countif dengan wildcard di excel"}]},{"@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\/4705"}],"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=4705"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4705\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}