SUMIF Function


SUMIF function is used to find the sum of cells satisfying a specific condition.

Function Type

Math and trigonometry


Get the sum of cells satisfying a specific criteria

Return value

A number equivalent to the sum of cells satisfying the specified condition




range – The range of cells to evaluate the criteria

criteria – The condition to check or the criterion to evaluate

sum_range – [optional] range of cells containing values to add. If sum_range is not specified, the corresponding values in range will be added.

Example 1


SUMIF function supports wildcards

To check multiple criteria, use SUMIFS function.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel