Excel references from fixed cell to column end

excelformulareference

I need an excel formula that calculates the SUM of all column cells from a fixed level until the last cell in the column. Like : SUM from S5 to the last S cell.
I tried : SUM(S5:S) but doesn't work.

There is a cell with the number of lines. Can I use a variable in the formula like : SUM(S5:S & A1) with A1 containing the number of lines ?

Best Solution

You might try =SUM(OFFSET(S5,0,0,ROWS(S:S)-ROW(S5)+1))

Related Question