Level 3Formulas That SpillPractice, 3 min
FILTER on two conditions
The task
Now only the West deals over $10,000. In F2, give
FILTER two conditions. In Google Sheets, each extra condition is just another input.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 | Big 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 |