AVERAGEIFS

StatisticalExcel 2007

Average cells meeting several conditions.

Syntax

AVERAGEIFS(average_range, criteria_range1, criteria1, …)

Examples

=AVERAGEIFS(score, class, "10A", subject, "Maths")

→

Related functions

AVERAGEIF SUMIFS

More Statistical functions

AVEDEV AVERAGE AVERAGEA AVERAGEIF BETA.DIST BETA.INV BINOM.DIST BINOM.DIST.RANGE BINOM.INV CHISQ.DIST CHISQ.DIST.RT CHISQ.INV

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.