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))`