SUM a block of cells
In F2, total the sales of every region in every quarter with one SUM over B2:D4.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | |||
| 2 | North | 120 | 95 | 140 | |||
| 3 | South | 80 | 110 | 90 | |||
| 4 | East | 60 | 75 | 85 | |||
| 5 | |||||||
| 6 | |||||||
| 7 | |||||||
| 8 |
Need help?
Why this works
A range can be a block: B2:D4 runs from the top-left corner B2 to the bottom-right corner D4 and covers all nine sales figures, 855 in total.
Common mistake: Starting the range at row 1. The headings aren't sales; start at B2, where the numbers begin.
The answer
- F2
=SUM(B2:D4)
+10 points