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])
- 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.