AVERAGEIFS practice exercises
Averages values whose rows match every condition. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 3701 | East | Kofi | 1 | 18 | 18 |
| 3 | 3702 | West | Kofi | 2 | 9 | 18 |
| 4 | 3703 | East | Kofi | 3 | 30 | 90 |
| 5 | 3704 | South | Kofi | 6 | 12 | 72 |
| 6 | 3705 | West | Ana | 3 | 9 | 27 |
| 7 | 3706 | South | Ana | 8 | 24 | 192 |
| 8 | 3707 | South | Lena | 8 | 24 | 192 |
| 9 | 3708 | West | Raj | 4 | 12 | 48 |
Average Revenue on orders sold by Lena.
Show answer
=AVERAGEIFS(F2:F9,C2:C9,"Lena")→ 192Average Revenue on orders sold by Ana.
Show answer
=AVERAGEIFS(F2:F9,C2:C9,"Ana")→ 109.5Average Revenue on orders sold by Raj.
Show answer
=AVERAGEIFS(F2:F9,C2:C9,"Raj")→ 48Average Revenue on orders sold by Kofi.
Show answer
=AVERAGEIFS(F2:F9,C2:C9,"Kofi")→ 49.5
New to AVERAGEIFS? Read the AVERAGEIFS guide first: syntax, a worked example and common mistakes.