{"id":523,"date":"2014-10-04T18:37:05","date_gmt":"2014-10-04T16:37:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=523"},"modified":"2020-06-05T23:58:07","modified_gmt":"2020-06-05T21:58:07","slug":"sumifs-function-wildcards","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-wildcards\/","title":{"rendered":"SUMIFS function: Wildcards *"},"content":{"rendered":"<p>The SUMIFS function can also Sum multiple criteria with matches that are similar but not exact.\u00a0 This can be done with the wildcards * and ?<\/p>\n<p>So if you have <em>John, Paul<\/em> and Ringo in your Sales Rep list and want to select just <em>John<\/em> and Ringo, then you would use &#8220;*o*&#8221; criteria.\u00a0 This means that any name that contains the letter <em>o<\/em> will be included in your sum.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/Qoq9lwTmOV4?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/SumIfs-Wildcards.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">SumIfs-Wildcards.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Here are more examples of how the wildcard characters work:<\/p>\n<table width=\"580\">\n<tbody>\n<tr>\n<td width=\"177\"><\/td>\n<td width=\"93\"><span style=\"color: #000000;\"><strong>*<\/strong><\/span><\/td>\n<td width=\"310\"><strong><span style=\"color: #000000;\">Returns any series of characters before\/after the asterisk<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td>Begins with\u2026<\/td>\n<td><span style=\"color: #0000ff;\">Glo*<\/span><\/td>\n<td><span style=\"color: #0000ff;\">Glo<\/span>bex Corporation<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><span style=\"color: #0000ff;\">Glo<\/span>bo Gym American Corp<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><span style=\"color: #0000ff;\">Glo<\/span>bo-Chem<\/td>\n<\/tr>\n<tr>\n<td>Ends with\u2026<\/td>\n<td><span style=\"color: #0000ff;\">*tech<\/span><\/td>\n<td>Ini<span style=\"color: #0000ff;\">tech<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Prima<span style=\"color: #0000ff;\">tech<\/span><\/td>\n<\/tr>\n<tr>\n<td>Contains\u2026<\/td>\n<td><span style=\"color: #0000ff;\">*inc*<\/span><\/td>\n<td>Acme, <span style=\"color: #0000ff;\">inc<\/span>.<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Demo, <span style=\"color: #0000ff;\">inc<\/span>.<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><span style=\"color: #0000ff;\">Inc<\/span>om Corporation<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Input, <span style=\"color: #0000ff;\">Inc<\/span>.<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Sample, <span style=\"color: #0000ff;\">inc<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><strong><span style=\"color: #000000;\">?<\/span><\/strong><\/td>\n<td><span style=\"color: #000000;\"><strong>Returns text that contains one variable<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td>Contains\u2026<\/td>\n<td><span style=\"color: #0000ff;\">a?c<\/span><\/td>\n<td><span style=\"color: #0000ff;\">ABC<\/span> Telecom<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Mon<span style=\"color: #0000ff;\">arc<\/span>h Playing Card Co.<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Sombr<span style=\"color: #0000ff;\">a C<\/span>orporation<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td>Spade and <span style=\"color: #0000ff;\">Arc<\/span>her<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SUMIFS function can also Sum multiple criteria with matches that are similar but not exact.\u00a0 This can be done with the wildcards * and ? So if you have John, Paul and Ringo in your Sales Rep list and want to select just John and Ringo, then you would use &#8220;*o*&#8221; criteria.\u00a0 This means [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,292],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/523"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=523"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/523\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17324"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}