Level 1Core FunctionsPractice, 2 min
SUM a range
The task
In B7, total the month's expenses with SUM and the range B2:B6.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Expense | Amount |
| 2 | Rent | 1400 |
| 3 | Groceries | 520 |
| 4 | Utilities | 180 |
| 5 | Gas | 140 |
| 6 | Phone | 85 |
| 7 | Total |