AVERAGEIF
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
StatisticalStatistics & Analysis
What it does
Averages cells that meet a single condition.
Syntax
AVERAGEIF(range, criteria, [average_range])
Arguments
range(range) — The range to check criteria against.criteria(criteria) — The condition (e.g. ">10", "Apple").average_range(range) — The actual cells to average (optional, defaults to 'range').
Examples
Average sales by region
Average Amount where Region is 'East'.
FORMULA
=AVERAGEIF(A2:A6, "East", B2:B6)
RESULT
150
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Region | Amount |
| 2 | East | 100 |
| 3 | West | 200 |
| 4 | East | 200 |
| 5 | North | 50 |
| 6 | East | 150 |