SUMIF Formula

SUMIF formula is used to add all numbers in a range of cells based on single criteria. Only single criteria can be applied in SUMIF formula. for multiple criteria SUMIFS formula can be used.

Syntax of SUMIF formula

SUMIF (range, criteria, [sum_range])

Parameters Details:

range: The range of cells that you want to apply the criteria against.
criteria : The criteria used to determine which cells to add.
sum_range : Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range.


The SUMIF function returns a numeric value.

SUMIF Formula Example
SUMIF Formula Example