Addition single cell

[Mmmdonuts]

Hello, trying in vain to work out how I can get a cell to add another cells number to its own and totalise it.


So example B1 = A1. I change the value in A1 and B1 then adds A1 + B1 it then displays the result in B1.

Can it be done?

[FDibbins]

Hi, welcome to the forum

This is not possible with regular formulas A cell can either contain a value or a formula, not both.

It can be done with VBA though

[skywriter]

Disregard, I should have refreshed before posting.

[Mmmdonuts]

Thanks. Ok so how would I go about having A1 paste its current value into another cell below every time it's changed. Then I could make B2 = the sum of all those numbers together.? Would this be a good work around. I would not expect the output of A1 to be infinite only last around 20 or so changes.

[Tony Valko]

You can do this with a formula.

See this...

http://mcgimpsey.com/excel/accumulator.html