Updating data on spreadsheet
I have data on Spreadsheet, let's say from Cell A1 - A 7.
I type on Cell A8 = sum(A1:A7)
After that, I insert a row above A7 and add a number in the new cell.
A8 copies the number on A7 earlier but A9 = sum(A1:A7).
I want A9 = sum(A1:A8)
What should I do to get the formula on the last cell of each column get updated after inserting rows in between? (This works in Excel.)
Thank you so much for your help.