Hi, I hope some one can help me.

I have a banking spreadsheet which I update daily. It is roughly set out as below:

BANKED TODAY: £500

BANKED FOR MONTH TO DATE: £9,000


Can I create a formula that adds ‘Banked Today’ to the ‘Month to Date’ figure so that when I update the ‘Banked Today’ figure tomorrow, it’ll add to a running total of £9,500?


EXAMPLE:

Say today is 10th of the month and the ‘Banked for month to date' total is £9,500

If on the 11th I changed the ‘Banked Today’ figure to £200, I want an autosum to add the £200 to the £9,500 so when I change the ‘Banked Today’ figure on the 12th, it’ll be added to £9,700?

Any help appreciated.

Thanks.

RGSL