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

SumIfs - Wildcards

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

 

 

 

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

Share on Google+