SUMIFS

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

Syntax

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

Arguments

Name	Description
SumRange	Cell-range to calculate sum for.
CriterionRange1	The cell-range which is checked against the criterion.
Criterion1	The 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

The sum of cell values which meet all specified criteria.

Examples

	A	B	C	D
1	230000	Freiburg	3	No
2	197000	Cologne	2	Yes
3	345678	Cologne	4	Yes
4	Freiburg	321900	2	Yes
5	Cologne	203000	3	No

Formula	Result	Comment
SUMIFS(A1:A5, B1:B5, "Cologne")	745678	Total price of all available houses in Cologne.
SUMIFS(A1:A5, B1:B5, "Freiburg", C1:C5, ">2")	230000	Total price of all available houses in Freiburg which have more than 2 rooms.