AVERAGEIFS

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

Syntax

=AVERAGEIFS(AverageRange, CriterionRange1, Criterion1, [CriterionRange2,...], [Criterion2,...])

Arguments

Name	Description
AverageRange	Cell-range to calculate average 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 average over all 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
AVERAGEIFS(A1:A5, B1:B5, "Cologne", C1:C5, ">2")	200000	Average price of houses in Cologne that have at least 3 rooms.
AVERAGEIFS(A1:A5, C1:C5, ">=4")	345678	Average price of houses with 4 or more rooms.
AVERAGEIFS(A1:A5, C1:C5, ">4")	#DIV/0!	No cell fulfills given criterion.