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")