The AVERAGEIF formula returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria in the parameter. It works with single criteria only.

Syntax of AVERAGEIF formula

AVERAGEIF( range, criteria, [average_range] )

Parameters details:

range : The range of cells that you want to apply the criteria against.
criteria : The criteria used to determine which cells to average.
average_range : Optional. It is the cells to average. If average_range is omitted, it uses range as the value for this parameter.


The AVERAGEIF function returns a numeric value.

AGERAGEIF Formula Example
AGERAGEIF Formula Example