excel - consecutive addition and increase in values

[tcbc71]

Help.

Attempting to use a Sum Formula to increase the value from one row t
the next within a column. For example A1 = 11, A2=5, and A3=6. As
enter into each iterative cell, I want the cell to reflect th
increasing total. A1 = 11, A2=16, A3=22 .....

When I do this I am getting a 'circular reference' error and canno
find a way around it

 

[Peo Sjoblom]

What do you enter? To get an accumulator see

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

in general it is not a good idea to use a circular reference since you
cannot audit
the formula

 

[radiation_rat]

why you dont made this in column B by using column A, so B1=A1; B2=A2+B1,
and just pull formula down?
You can always hide A column if you want.