Sum or subtract

Hi Rhoda

Thanks for your question.

The best way to do this is to SUM all of your outgoing costs first, then subtract this total from your budget. By doing this you can easily add more outgoings and recalculate quickly.

To do this:
- Select all the cells containing your outgoing costs (hopefully these are listed in a column)
- On your Home ribbon, click on the Autosum button on the right hand side. This should sum up all of the selected cells into a cell at the bottom of the column.
- Click in the cell where you want to calculate the new budget
- Type ="cell with budget"-"cell with total costs"
(use your relevant cell references)
and press enter

Hope this answers your question, let us know if you need any more help.

Kind Regards,

Sarah
Microsoft Trainer