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… *tech Initech
Primatech
Contains… *inc* Acme, inc.
Demo, inc.
Incom Corporation
Input, Inc.
Sample, inc
? Returns text that contains one variable
Contains… a?c ABC 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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+