Course
FILTER practice exercises
Five exercises, from your first FILTER to two conditions taken from cells. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Add up one region’s sales
In F2, use FILTER to keep only the sales of the North region from D2:D11, and wrap it in SUM to get their total.
| Region | Rep | Product | Sale ($) | North total ($) | |
| South | Ava | Laptop | 1,450.00 | ||
| North | Liam | Monitor | 820.00 | ||
| East | Noah | Printer | 1,980.00 | ||
| North | Mia | Laptop | 1,340.00 | ||
| West | Ethan | Desk chair | 610.00 | ||
| North | Olivia | Printer | 2,150.00 | ||
| South | Lucas | Monitor | 930.00 | ||
| East | Emma | Desk chair | 1,120.00 | ||
| North | Jack | Desk chair | 470.00 | ||
| West | Sofia | Laptop | 1,760.00 |