{"id":2848,"date":"2023-07-20T10:30:32","date_gmt":"2023-07-20T10:30:32","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-sumif-joker\/"},"modified":"2023-07-20T10:30:32","modified_gmt":"2023-07-20T10:30:32","slug":"excel-sumif-joker","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-sumif-joker\/","title":{"rendered":"Excel: cara menggunakan wildcard dalam fungsi sumifs"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menjalankan fungsi <strong>SUMIFS<\/strong> dengan wildcard di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#Sum values in B2:B10 where cells in A2:A10 contains string<\/span>\n=SUMIFS( <span style=\"color: #3366ff;\">B2:B10<\/span> , <span style=\"color: #ff0000;\">A2:A10<\/span> , \"*string*\")\n\n<span style=\"color: #008080;\">#Sum values in B2:B10 where cells in A2:A10 start with string<\/span>\n=SUMIFS( <span style=\"color: #3366ff;\">B2:B10<\/span> , <span style=\"color: #ff0000;\">A2:A10<\/span> , \"string*\")\n\n<span style=\"color: #008080;\">#Sum values in B2:B10 where cells in A2:A10 end with string<\/span>\n=SUMIFS( <span style=\"color: #3366ff;\">B2:B10<\/span> , <span style=\"color: #ff0000;\">A2:A10<\/span> , \"*string\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24949 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique1-1.jpg\" alt=\"\" width=\"455\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: SUMIFS dengan sel yang berisi string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menambahkan nilai pada kolom <strong>Poin<\/strong> dimana sel di kolom <strong>Tim<\/strong> memiliki nama \u201cets\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIFS( <span style=\"color: #3366ff;\">B2:B10<\/span> , <span style=\"color: #ff0000;\">A2:A10<\/span> , \"*ets*\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24950 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique2.jpg\" alt=\"\" width=\"518\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin untuk tim yang namanya mengandung \u201cets\u201d adalah <strong>50<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menjumlahkan poin tim yang namanya mengandung \u201cets\u201d:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Tim dengan nama \u201cets\u201d<\/strong> : Nets, Rockets, Hornets<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jumlah poin<\/strong> : 17 + 21 + 12<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jumlah poin<\/strong> : 50<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: SUMIFS dengan sel yang dimulai dengan string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menjumlahkan nilai pada kolom <strong>Poin<\/strong> dimana sel pada kolom <strong>Tim<\/strong> diawali dengan \u201cbu\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIFS( <span style=\"color: #3366ff;\">B2:B10<\/span> , <span style=\"color: #ff0000;\">A2:A10<\/span> , \"bu*\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24951 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique3-1.jpg\" alt=\"\" width=\"521\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin untuk tim yang namanya dimulai dengan \u201cbu\u201d adalah <strong>50<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menjumlahkan poin tim yang namanya dimulai dengan \u201cbu\u201d:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Nama tim yang dimulai dengan \u201cbu\u201d<\/strong> : Bucks, Bulls<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jumlah poin<\/strong> : 15 + 34<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jumlah poin<\/strong> : 49<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: SUMIFS dengan sel yang diakhiri dengan string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menjumlahkan nilai pada kolom <strong>Poin<\/strong> dimana sel pada kolom <strong>Tim<\/strong> diakhiri dengan \u201cavs\u201d pada namanya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIFS( <span style=\"color: #3366ff;\">B2:B10<\/span> , <span style=\"color: #ff0000;\">A2:A10<\/span> , \"*avs\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24952 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique4.jpg\" alt=\"\" width=\"514\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah poin untuk tim dengan nama berakhiran \u201cavs\u201d adalah <strong>54<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menjumlahkan poin tim yang namanya diakhiri dengan \u201cavs\u201d:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Nama tim yang diakhiri dengan \u201cavs\u201d<\/strong> : Mavs, Cavs<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jumlah poin<\/strong> : 24 + 30<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jumlah poin<\/strong> : 54<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/\" target=\"_blank\" rel=\"noopener\">Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menjalankan fungsi SUMIFS dengan wildcard di Excel: #Sum values in B2:B10 where cells in A2:A10 contains string =SUMIFS( B2:B10 , A2:A10 , &#8220;*string*&#8221;) #Sum values in B2:B10 where cells in A2:A10 start with string =SUMIFS( B2:B10 , A2:A10 , &#8220;string*&#8221;) #Sum values in B2:B10 where cells in A2:A10 end [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara menggunakan wildcard dalam fungsi SUMIFS - Statorials<\/title>\n<meta name=\"description\" content=\"Fungsi ini menjelaskan cara menggunakan wildcard dalam fungsi SUMIFS di Excel, dengan sebuah 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-sumif-joker\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan wildcard dalam fungsi SUMIFS - Statorials\" \/>\n<meta property=\"og:description\" content=\"Fungsi ini menjelaskan cara menggunakan wildcard dalam fungsi SUMIFS di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-sumif-joker\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T10:30:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique1-1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-joker\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-sumif-joker\/\",\"name\":\"Excel: Cara menggunakan wildcard dalam fungsi SUMIFS - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T10:30:32+00:00\",\"dateModified\":\"2023-07-20T10:30:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Fungsi ini menjelaskan cara menggunakan wildcard dalam fungsi SUMIFS di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-joker\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-sumif-joker\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-joker\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan wildcard dalam fungsi sumifs\"}]},{\"@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":"Excel: Cara menggunakan wildcard dalam fungsi SUMIFS - Statorials","description":"Fungsi ini menjelaskan cara menggunakan wildcard dalam fungsi SUMIFS di Excel, dengan sebuah 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-sumif-joker\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan wildcard dalam fungsi SUMIFS - Statorials","og_description":"Fungsi ini menjelaskan cara menggunakan wildcard dalam fungsi SUMIFS di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-sumif-joker\/","og_site_name":"Statorials","article_published_time":"2023-07-20T10:30:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/caractere-generique1-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-sumif-joker\/","url":"https:\/\/statorials.org\/id\/excel-sumif-joker\/","name":"Excel: Cara menggunakan wildcard dalam fungsi SUMIFS - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T10:30:32+00:00","dateModified":"2023-07-20T10:30:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Fungsi ini menjelaskan cara menggunakan wildcard dalam fungsi SUMIFS di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-sumif-joker\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-sumif-joker\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-sumif-joker\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan wildcard dalam fungsi sumifs"}]},{"@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\/2848"}],"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=2848"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2848\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}