AVERAGEIF
Returns the average of all cell values in a cell-range which meet a given criterion. To specify multiple criteria please use AVERAGEIFS.
Syntax
=AVERAGEIF(DataRange, Criterion, [AverageRange])
Arguments
| Name | Description |
|---|---|
| DataRange | Cell-range to calculate average for. |
| Criterion | The criterion each cell has to fulfill. |
| AverageRange (optional) | If given these cells are used to calculate average. If ommitted DataRange is used. |
Return
The average over all cell values which meet criterion.
Examples
| A | B | |
|---|---|---|
| 1 | 100000 | 200 |
| 2 | 200000 | 400 |
| 3 | 300000 | 400 |
| 4 | North | 600 |
| 5 | East | 800 |
| 6 | South | 1000 |
| Formula | Result | Comment |
|---|---|---|
| 150000 | Only cells A1 and A2 match given criterion |
| 800 | Take cells from column A which end with "th" and average corresponding values from column B |