Running Sum adding to one cell

[IsimiKehinde]

I want a running sum whereby the a cell retains a value as they add to it from another single cell.

So lets say a value (in this example; 2000) is put into A1, it then goes to cell B1 (making it 2000 as well); I want that if the value in A1 is changed (lets say 1000), i want it to go into B1 and add to the value that is in it (which is 2000 it now becomes 3000).
So anytime a new value is put in A1, it adds to what is in B1

Is it possible and if so; is there any way it can be done as a formula and not VBA?

Thanks

 

[jasonb75]

A formula can only look at what is there now, not what was there before. If you want to use a formula then you will need to enter each new figure into a separate cell and sum them together without deleting or overwriting the previous entries.

If you want to do it with a single cell then you will need to use vba.