What is left after the bills
In B9, work out how much is left each month after the fixed bills: the income in B2 minus all the bills in B3:B8. Subtract one SUM instead of each bill on its own.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Per month | ||||
| 2 | Income after tax | 8000 | ||||
| 3 | Rent | 3000 | ||||
| 4 | Electricity and heating | 600 | ||||
| 5 | Transportation | 400 | ||||
| 6 | Phone and internet | 250 | ||||
| 7 | Insurance | 350 | ||||
| 8 | Subscriptions | 150 | ||||
| 9 | Left after the bills | |||||
| 10 |
Need help?
Why this works
SUM(B3:B8) adds up the six fixed bills to 4,750, and B2 minus that total is 3,250, the money left for food, clothes and everything else. One SUM is shorter than B2-B3-B4-B5-B6-B7-B8, and when you insert a new bill inside the range, the total picks it up.
Common mistake: Writing =B2-B3:B8. That subtracts each bill from the income on its own instead of their total, so put SUM around the range.
The answer
- B9
=B2-SUM(B3:B8)
Subtract the total of the bills from the income, for example =B2-SUM(B3:B8) with the income in B2 and the bills in B3:B8.
+10 points