SUMIF
Name
Sumif
Description
Adds the cells using a given criteria.
Syntax
SUMIF(array,condition,sumrange )
Remarks
This function has the following 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 |
condition | Condition that determines which cells are added, as text, number, or expression |
sumrange | [Optional] Range of cells to add; if omitted, then all the cells in the array are added |
Data Type
Accepts numeric data for array and sumrange. Accepts text, numeric, or expression data for condition. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
SUMIF(A1:B7,">150",C1:C11)
SUMIF(A1:A9,">150")