Navigation:  Formula Reference > Spreadsheet Formula Functions >

SUMIFS

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

COUNTIF

SUM

SUMPRODUCT