Level 3Formulas That SpillPractice, 3 min
FILTER one region
The task
In F2, list every deal from the West region with
FILTER. One formula, and the list grows or shrinks with the data.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Deal | Rep | Region | Amount | West deals | |
| 2 | Northwind | Maya | West | $18,500 | ||
| 3 | Cobalt Labs | Theo | East | $7,200 | ||
| 4 | Brightline | Priya | West | $9,400 | ||
| 5 | Fieldstone | Jonah | Central | $22,800 | ||
| 6 | Harbor & Co | Lena | East | $13,100 | ||
| 7 | Quillworks | Maya | West | $11,250 | ||
| 8 | Ridgeview | Theo | Central | $5,600 | ||
| 9 | Summit Bank | Priya | West | $26,400 |