I just tried the following formula in a test worksheet and it seemed to work:
Code:
=SUM(S119:OFFSET(S119,S124,0))
So apparently I can use a value in the range as one of the offsets. Guess that's not the problem.
I notice in your case your range runs across a single row rather than down a column. I suppose you meant it to be that way?