Skip to main content
Version: Streamsheets 2.5

AVERAGEIFS

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

Syntax

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

Arguments

NameDescription
AverageRangeCell-range to calculate average 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

The average over all cell values which meet all specified criteria.

Examples

ABCD
1230000Freiburg3No
2197000Cologne2Yes
3345678Cologne4Yes
4Freiburg3219002Yes
5Cologne2030003No
FormulaResultComment
AVERAGEIFS([object Object], [object Object], [object Object], [object Object], [object Object])
200000Average price of houses in Cologne that have at least 3 rooms.
AVERAGEIFS([object Object], [object Object], [object Object])
345678Average price of houses with 4 or more rooms.
AVERAGEIFS([object Object], [object Object], [object Object])
#DIV/0!No cell fulfills given criterion.