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