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