Excel Magic Trick 1237: Add with 'Contains Criteria' or Partial Text Criteria: SUMIFS & Wildcard

Download Excel Start File:

Download File:
Learn how to add with "Contains Criteria" or Partial Text Criteria using the: SUMIFS function and the Wildcard, Asterisk, which stands for zero or more wildcard characters.

Excel,Microsoft Excel,Highline College,Mike Girvin,excelisfun,Michael Girvin,Mike excelisfun Girvin,Slaying Excel Dragons,Excel Magic Tricks,Ctrl Shift Enter Mastering Excel Array Formulas,Array Formulas,Add with Contains Criteria or Partial Text Criteria: SUMIFS & Wildcard,Add with Contains Criteria,Add with Partial Text Criteria,SUMIFS & Wildcard,SUMIFS and asterisk,zero or more wildcard characters,Adding Fuzzy,Fuzzy Adding,Approximate adding,SUMIFS,