AVERAGEIF function


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



=AVERAGEIF( rangecriteria[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.