How to write a formula to sum a column over a cell?

Question

Google Sheets

If it is not known how many cells will be above the cell with the formula, then how to make a formula so that the first cell from the top does not fall into the values?

Answer 1

Like this:
=СУММ(ДВССЫЛ("R2C[0]:R[-1]C";0))

Answer 2

find the position of the cell for example 4 column 3 row and set the range 4 column 3-1 row