In Google Sheets, how do I get - at the bottom-most cell of a column - the sum of each cell (except for row 1, the header) above in that column? Keep in mind, I may add rows in the future.
There are various ways how to solve this. The most simple would be to use dragging
Then all you need to do is insert new rows inside of the
SUM range so it would automatically expand as needed:
As a next-level move, you can use
INDIRECT where you can use
ROW()-1 to always get the range from A2 cell to the row where this formula resides minus 1 row: