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.
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|
|?||Returns text that contains one variable|
|Monarch Playing Card Co.|
|Spade and Archer|