Forum Discussion
Autosum
Hi I have a long column of numbers and I am Going down the column auto summing. I want to automatically select the cells in the column up to the cell that was the start of the last autosum ( so that I...
If the SUM() formula is in the same column you can use the following formula:
=SUM(OFFSET($A$2,0,0,ROW()-2,1))If you are on a different column just SUM(A:A)