Wildcards

Certain Excel functions like SUMIF and SUMIFS support thewildcardcharacters “?”

Notice you must enclose the text and the wildcard in double quotes ("").

Also note that SUMIF isnotcase-sensitive.

Excel formula: Sum if cells contain specific text

The criteria “sha*” will match “Shampoo”, or “SHAMPOO”.

SUMIFS solution

it’s possible for you to also use theSUMIFS functionto sum if cells begin with.

SUMIFS can handlemultiplecriteria, and the order of the arguments is different from SUMIF.

Excel formula: Sum if not blank

Like SUMIF, the SUMIFS function isnotcase-sensitive.

Criteria can be applied to dates, numbers, and text.

How to use the SUMIF function

Excel formula: Sum if cells are equal to

Excel formula: Sum if cells are not equal to

Excel formula: Sum if x or y

Excel SUMIF function

Excel SUMIFS function

Article image