Cumulative Totals

[RGSL]

Hello, 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 month and the ‘Banked for month to date total’ is £9,500

If on the 11th I changed the ‘Banked Today’ figure to £200.00, 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. If you need me to explain further let me know.

Thanks.

RGSL

[Fotis1991]

http://www.excelforum.com/excel-form...31#post3259431

One hour earlier..

[arlu1201]

Thanks Fotis.

RGSL,

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.