AVERAGEIF
Averages only the rows that meet a condition.
How it’s written
AVERAGEIF(range_to_check, what_to_look_for, range_to_average)Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Amara | 400 |
| 3 | South | Ben | 250 |
| 4 | North | Chloe | 150 |
| 5 | West | Dev | 700 |
=AVERAGEIF(A2:A5,"North",C2:C5)Result: 275
Averages the two North sales figures.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
If nothing matches you’ll get #DIV/0!, so wrap it in IFERROR if that could happen.
Practice it properly
Statistics for one group gives you real tasks, with your formulas tested on data you haven’t seen.