Excel references from fixed cell to column end?

excel, formula, reference

Solution

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

Problem

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 ?

Original source