AVERAGEIF function


DESCRIPTION:

Return the average (arithmetic mean) of its arguments specified by a given criteria.

 

SYNTAX:

=AVERAGEIF( range, criteria[average_range] )

 

REQUIRED ARGUMENTS:

range

The range of cells that you want to apply the criteria against.

criteria

The criteria used to determine for which numbers calculate the average.

 

OPTIONAL ARGUMENTS:

[average_range]

The cells to average. When omitted, the range is used.