SUMIF Formula

SUMIF formula is used to add all numbers in a range of cells based on one criteria. Only one criteria can 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