AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple criteria.
StatisticalStatistics & Analysis
What it does
Averages cells that meet multiple conditions.
Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Arguments
average_range(range) — The range to average.criteria_range1(range) — First range to check.criteria1(criteria) — First condition.
Examples
Multi-condition average
Average Amount for 'East' region and 'Apples'.
FORMULA
=AVERAGEIFS(C2:C6, A2:A6, "East", B2:B6, "Apples")
RESULT
110
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Region | Product | Amount |
| 2 | East | Apples | 100 |
| 3 | West | Apples | 200 |
| 4 | East | Oranges | 150 |
| 5 | East | Apples | 120 |
| 6 | North | Apples | 90 |