Skip to main content
Version: Streamsheets 3.0

SUMIFS

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

Syntax

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

Arguments

NameTypeDescription
SumRangeRangeCell-range to calculate sum for.
CriterionRange1RangeThe cell-range which is checked against the criterion.
Criterion1StringThe criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,... (optional)RangeAdditional cell-range which is checked against next criterion.
Criterion2,... (optional)StringAdditional criterion each cell of CriterionRange2 has to fulfill.

Return

TypeDescription
NumberThe sum of cell values which meet all specified criteria.

Examples

ABCD
1230000Freiburg3No
2197000Cologne2Yes
3345678Cologne4Yes
4Freiburg3219002Yes
5Cologne2030003No
FormulaResultComment
=SUMIFS(A1:A5, B1:B5, "Cologne")
745678Total price of all available houses in Cologne.
=SUMIFS(A1:A5, B1:B5, "Freiburg", C1:C5, ">2")
230000Total price of all available houses in Freiburg which have more than 2 rooms.