Add up a column with SUM
Step 1 of 3
SUM adds up numbers. Instead of =B2+B3+B4+B5, you give it the whole range at once: =SUM(B2:B5).
Click Continue when you're ready.
Already know it? Type the formula straight into B6.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Fruit | Units | ||||
| 2 | Apple | 12 | ||||
| 3 | Pear | 7 | ||||
| 4 | Plum | 9 | ||||
| 5 | Kiwi | 4 | ||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
=SUM(B2:B5) adds every number from B2 down to B5: 12 + 7 + 9 + 4 = 32. If one of the numbers changes, the total follows.
Common mistake: Stopping the range one row short, like B2:B4. Check that the range reaches the last number.
The answer
- B6
=SUM(B2:B5)
Type =SUM( then select the cells, close the parenthesis and press Enter, for example =SUM(B2:B5).
+10 points