Updating data on spreadsheet

tphanyamada shared this question 10 months ago
Needs Answer

Hello there,

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.

© 2021 International GeoGebra Institute