Level 1Summarizing DataPractice, 3 min
SUMIF
The task
In E2, total the order amounts for the West region only.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Region | Amount | West total | |
| 2 | 1001 | West | 120 | ||
| 3 | 1002 | East | 75 | ||
| 4 | 1003 | West | 60 | ||
| 5 | 1004 | South | 200 | ||
| 6 | 1005 | West | 45 | ||
| 7 | 1006 | East | 90 |