Skip to main content
Version: Streamsheets 2.4

SUMIFS

Returns the sum of all cell values which meet multiple criteria.

Syntax

=SUMIFS(SumRange, CriterionRange1, Criterion1, [CriterionRange2, Criterion2], ...)

Arguments

NameDescription
SumRangeCell-range to calculate sum for.
CriterionRange1The cell-range which is checked against the criterion.
Criterion1The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,...Optional. Additional cell-range which is checked against next criterion.
Criterion2,...Optional. Additional criterion each cell of CriterionRange2 has to fulfill.

Return Value

The sum of cell values which meet all specified criteria.

Example

ABCD
1230000Freiburg3No
2197000Cologne2Yes
3345678Cologne4Yes
4321900Freiburg2Yes
5203000Cologne3No
FunctionResultComment
SUMIFS(A1:A5, B1:B5, "Cologne")745678Total price of all avaialable houses in Cologne.
SUMIFS(A1:A5, B1:B5, "Freiburg", C1:C5, ">2")230000Total price of all avaialable houses in Freiburg which have more than 2 rooms.