Exercises / Foundations · 3 of 12
Total a monthly budget
SUM adds up numbers. Give it a range like B2:B7 and it adds every cell from B2 down to B7.
SUM(number1, [number2], …)Syntax
Adds numbers or ranges.
Your taskIn B8, use SUM to add up all the expenses in B2:B7.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Expense | Amount | ||||
| 2 | Rent | $950.00 | ||||
| 3 | Groceries | $320.00 | ||||
| 4 | Transport | $85.00 | ||||
| 5 | Phone | $40.00 | ||||
| 6 | Gym | $35.00 | ||||
| 7 | Streaming | $18.00 | ||||
| 8 | Total | |||||
| 9 | ||||||
| 10 |