excel - consecutive addition and increase in values

T

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
 
R

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.
 
Top