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.

YouTube video

SUMIFS function: Wildcards * | MyExcelOnline

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 RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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