In cell A1 I can't write
=SUM(A:A) (Circular reference). If I write
=SUM(A2:A15) when I insert A16 the result won't be affected. How to do this?
To sum up all cells in the entire column except the one cell in the same column that you put the formula in (namely
for MS Office 2007 and later, or use
for MS Office 2003 and earlier.
You could move the =SUM(A:A) to another column or you could set A1 as =SUM(A2:A20000).