AVERAGEIF function in Excel

AVERAGEIF averages cells that meet a condition.

Syntax

=AVERAGEIF(range, criteria, [average_range])

Argument	Required?	What it is
range	Required	The cells to check against the criteria.
criteria	Required	The condition, such as "North", ">100" or a cell reference. Text and comparisons go in quotes.
average_range	Optional	The cells to average. If left out, the cells in range are averaged.

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

AVERAGEIF averages cells that meet a condition.

=AVERAGEIF(range, criteria, [average_range])

Argument	Required?	What it is
range	Required	The cells to check against the criteria.
criteria	Required	The condition, such as "North", ">100" or a cell reference. Text and comparisons go in quotes.
average_range	Optional	The cells to average. If left out, the cells in range are averaged.

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