Sum a column at the bottom of it

Question

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.

Answer 1

There are various ways how to solve this. The most simple would be to use dragging SUM:

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 ARRAYFORMULA with 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:

=ARRAYFORMULA(TRANSPOSE(MMULT(
 TRANSPOSE(INDIRECT("A2:C"&ROW()-1)),
       ROW(INDIRECT("A2:A"&ROW()-1))^0)))

Answer 2

The formula provided is correct but does not take under consideration empty cells.

To fix the empty cells issue use the following corrected formula.

=ARRAYFORMULA(TRANSPOSE(MMULT(
 TRANSPOSE(INDIRECT("A2:B"&ROW()-1))*1,
       ROW(INDIRECT("A2:A"&ROW()-1))^0)))

(notice the *1)