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
Bookmarks