The SUMIFS function can also Sum multiple criteria with matches that are similar but not exact.  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 “*o*” criteria.  This means that any name that contains the letter o will be included in your sum.


DOWNLOAD WORKBOOK

 

Here are more examples of how the wildcard characters work:

*Returns any series of characters before/after the asterisk
Begins with…Glo*Globex Corporation
Globo Gym American Corp
Globo-Chem
Ends with…*techInitech
Primatech
Contains…*inc*Acme, inc.
Demo, inc.
Incom Corporation
Input, Inc.
Sample, inc
?Returns text that contains one variable
Contains…a?cABC Telecom
Monarch Playing Card Co.
Sombra Corporation
Spade and Archer

 

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn