Pinterest Pixel

SUMIFS function: Wildcards *

SUMIFS function: Wildcards * The SUMIFS function can also Sum multiple criteria with matches that are similar... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

SUMIFS function: Wildcards * | MyExcelOnline SUMIFS function: Wildcards * | MyExcelOnline

SUMIFS function: Wildcards *

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 workbookSumIfs-Wildcards.xlsx

 

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
See also  UNIQUE Formula in Excel

 

 

If you like this Excel tip, please share it
SUMIFS function: Wildcards * | MyExcelOnline SUMIFS function: Wildcards * | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...