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] )
- 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.