SUMIFS practice exercises
Adds values whose row matches 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 | 4401 | South | Lena | 3 | 30 | 90 |
| 3 | 4402 | East | Lena | 9 | 60 | 540 |
| 4 | 4403 | North | Lena | 4 | 15 | 60 |
| 5 | 4404 | North | Ana | 9 | 15 | 135 |
| 6 | 4405 | East | Theo | 4 | 9 | 36 |
| 7 | 4406 | East | Raj | 4 | 30 | 120 |
| 8 | 4407 | West | Raj | 5 | 12 | 60 |
| 9 | 4408 | South | Theo | 7 | 12 | 84 |
Total Revenue from South orders sold by Theo.
Show answer
=SUMIFS(F2:F9,B2:B9,"South",C2:C9,"Theo")→ 84Total Revenue from North orders sold by Lena.
Show answer
=SUMIFS(F2:F9,B2:B9,"North",C2:C9,"Lena")→ 60Total Revenue from West orders sold by Raj.
Show answer
=SUMIFS(F2:F9,B2:B9,"West",C2:C9,"Raj")→ 60Total Revenue from South orders sold by Lena.
Show answer
=SUMIFS(F2:F9,B2:B9,"South",C2:C9,"Lena")→ 90Total Revenue from North orders sold by Ana.
Show answer
=SUMIFS(F2:F9,B2:B9,"North",C2:C9,"Ana")→ 135Total Revenue from East orders sold by Raj.
Show answer
=SUMIFS(F2:F9,B2:B9,"East",C2:C9,"Raj")→ 120
New to SUMIFS? Read the SUMIFS guide first: syntax, a worked example and common mistakes.