Course
SUMIFS practice exercises
Five exercises, from your first two-condition total to a summary table. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Total for one salesperson in one region
In F2, write a SUMIFS that adds the amounts in column D for Olivia Reed in the North region, using the orders in A1:D13.
| Region | Salesperson | Product | Amount ($) | Olivia Reed, North ($) | |
| West | Emma Hughes | Monitor 27" | 640.00 | ||
| South | James Carter | Monitor 24" | 420.00 | ||
| East | Sofia Patel | Laptop 15" | 1,480.00 | ||
| North | Liam Brooks | Keyboard | 180.00 | ||
| North | Olivia Reed | Laptop 14" | 980.00 | ||
| South | Noah Bennett | Laptop 14" | 1,000.00 | ||
| North | Olivia Reed | Monitor 27" | 1,150.00 | ||
| East | Ava Collins | Headset | 240.00 | ||
| North | James Carter | Laptop 15" | 1,520.00 | ||
| South | Sofia Patel | Keyboard | 95.00 | ||
| West | Olivia Reed | Laptop 14" | 870.00 | ||
| North | Emma Hughes | Keyboard | 500.00 |