Forum Discussion

Tracyk1025's avatar
Tracyk1025
Copper Contributor
Dec 10, 2021

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

3 Replies

  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Bronze Contributor
    Dec 10, 2021

    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)

    • Tracyk1025's avatar
      Tracyk1025
      Copper Contributor
      Dec 10, 2021

      hIJuliano-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

Resources