Adds numbers within a range that meet a specified condition.
Sample Usage
SUMIF(Quantity:Quantity, >25, Cost:Cost)
Syntax
SUMIF(
- range
- criterion
- [sum_range]
- range—The group of cells to evaluate.
- criterion—The condition that defines which numbers to add (for example: 15, "Hello World!", >25).
- sum_range—[optional]The group of cells to add, if different from the range.
Usage Notes
- For criterion, acceptable operators include: = (equal to), <> (not equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to).