Excel SUMIF Function

Using the Excel SUMIF Function


The Excel SUMIF function expands the capabilities of the SUM function and is used to add individual values in a range that meet a criteria that you specify. Criteria can be based on dates, numbers and text. The function supports the use of logical operators (<, >, =, <>) and wildcards (*, ?).


=SUMIF (range, criteria, [sum_range])

Syntax Breakdown

The range argument is required and is the range of cells that you would like to evaluate by the criteria argument. Cells that are blank or contain text values will be ignored. Dates in standard Excel format are accepted.

Criteria is also required and can be entered in the form of a number, expression, cell reference, text or a function that defines which cells will be added together. Examples of criteria include, 10, "<10", A5, "10", or TODAY().

It is important to enclose text criteria and criteria that contains logical or mathematical symbols in double quotation marks ("). Numeric criteria does not require double quotation marks.

The sum_range argument is optional. This argument is for actual cells you would like to add other than those contained in the range argument. If the sum_range argument is blank, Excel simply adds the cells specified in range.

Usage Notes

The SUMIF function returns is used to add together cells in a range that meet a user specified criteria.

Using Wildcard Characters
Wildcard characters, such as the question mark (?) and asterisk (*) can be used in the criteria argument. The question mark will match any single character and the asterisk will match any sequence of characters.

If you are searching for an actual question mark or asterisk, then enter the tilde (~) character before the question mark or asterisk (i.e. ~* or ~?).

Excel SUMIF Wildcard Example

Multiple Criteria
If you need to sum cells using multiple criteria, see the SUMIFS function.