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… *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

 

3

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