AVERAGEIFS function in Excel

AVERAGEIFS averages cells that meet several conditions.

Syntax

=AVERAGEIFS(average_range, criteria_range1, criteria1, …)

Argument	Required?	What it is
average_range	Required	The cells to average. If left out, the cells in range are averaged.
criteria_range1	Required	The first range to test. Add more range/criteria pairs for more conditions.
criteria1, …	Required	The condition for criteria_range1, such as "North" or ">100".

Type the formula yourself and get it graded instantly, no Excel needed.

AVERAGEIFS averages cells that meet several conditions.

=AVERAGEIFS(average_range, criteria_range1, criteria1, …)

Argument	Required?	What it is
average_range	Required	The cells to average. If left out, the cells in range are averaged.
criteria_range1	Required	The first range to test. Add more range/criteria pairs for more conditions.
criteria1, …	Required	The condition for criteria_range1, such as "North" or ">100".

Type the formula yourself and get it graded instantly, no Excel needed.