Autosum

[Tracyk1025]

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 don’t have to laboriously select all the cells upwards. Is this possible?

[#2]

@Tracyk1025 

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)

[#3]

hI@Juliano-Petrukio 

 I dont think i explained it very well!

 my list of data is in column A and i am summing in column  B and i want the highlighted action to happen automatically rather than me having to select the cells to be summed. ie  for it to automatically sum to cell A9 in this case ( realizing that cell A8 has already been part of the previous sum)

thanks

[#4]

@Tracyk1025 

Simpler

=SUM($A$1:A15,-$B$1:B15)