SUMIF: total sales for one region
Lesson 4 of 5In cell D2, write a formula that adds up all Sales where the Region is "North".
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Sales | North total | |
| 2 | North | 1,200 | ||
| 3 | South | 850 | ||
| 4 | North | 640 | ||
| 5 | East | 410 | ||
| 6 | North | 300 | ||
| 7 | West | 720 | ||
| 8 | South | 515 | ||
| 9 | North | 980 |
Type in the formula bar above and press Enter to check.