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