SUMIF practice exercises
Adds values whose row matches a 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 | 4101 | West | Omar | 4 | 15 | 60 |
| 3 | 4102 | East | Ines | 1 | 30 | 30 |
| 4 | 4103 | East | Maya | 8 | 45 | 360 |
| 5 | 4104 | East | Maya | 5 | 9 | 45 |
| 6 | 4105 | North | Ana | 9 | 45 | 405 |
| 7 | 4106 | South | Ana | 7 | 60 | 420 |
| 8 | 4107 | East | Ines | 5 | 15 | 75 |
| 9 | 4108 | South | Omar | 6 | 30 | 180 |
How many Units did Ines sell in total?
Show answer
=SUMIF(C2:C9,"Ines",D2:D9)→ 6Total Revenue from East orders.
Show answer
=SUMIF(B2:B9,"East",F2:F9)→ 510How many Units did Omar sell in total?
Show answer
=SUMIF(C2:C9,"Omar",D2:D9)→ 10Total Revenue from North orders.
Show answer
=SUMIF(B2:B9,"North",F2:F9)→ 405How many Units did Ana sell in total?
Show answer
=SUMIF(C2:C9,"Ana",D2:D9)→ 16Total Revenue from South orders.
Show answer
=SUMIF(B2:B9,"South",F2:F9)→ 600
New to SUMIF? Read the SUMIF guide first: syntax, a worked example and common mistakes.