This function adds the cells in a range using multiple criteria.
Syntax
SUMIFS(array,conditionarray,condition,...)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| array | Range of cells to check; each cell in the array can be a double-precision floating-point value or an integer value |
| conditionarray | Range of cells to check; each cell in the array can be a double-precision floating-point value or an integer value |
| condition | Condition that determines which cells are added, as a text, number, or expression (where expressions use the relational operators detailed in Operators in a Formula) |
Data Types
Accepts numeric data for array. Accepts text, numeric or expression data for condition. Returns numeric data.
Examples
SUMIFS(A1:A10, B1:B10,">0",C1:C10,"<10")
Version Available
This function is available in product version 5.0 or later.
See Also
SUMPRODUCT | SUM | COUNTIF | Math and Trigonometry Functions