Spread Formula Reference
SUMIF
Formula Functions > Functions R to S > SUMIF

This function adds the cells using a given criteria.

Syntax

SUMIF(array,condition,sumrange)

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
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)
sumrange [Optional] Range of cells to add; if omitted, then all the cells in the array are added

Data Types

Accepts numeric data for array and sumrange. Accepts text, numeric or expression data for condition. Returns numeric data.

Examples

SUMIF(A1:B7,">150",C1:C11)

SUMIF(A1:A9,">150")

Version Available

This function is available in product version 2.0 or later.

See Also

SUMPRODUCT | SUM | COUNTIF | Math and Trigonometry Functions