FormuladrillAdd it up
Five monthly costs are listed. Select cell B7, type a formula that adds all five, press Enter, then press Enter again (or choose Check answer).
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Cost | ||
| 2 | Rent | $1,450.00 | ||
| 3 | Utilities | $210.50 | ||
| 4 | Internet | $65.00 | ||
| 5 | Groceries | $480.00 | ||
| 6 | Transport | $120.00 | ||
| 7 | Total |
Green cells are yours. The sheet works like Excel: type in a cell or the formula bar, Enter, Tab, Shift+arrows, Ctrl+C and Ctrl+V, Ctrl+D, the fill handle, F2, F4, Ctrl+Z. Press Enter on a cell when you are done to check.