variable column

[Libby]

I have spreadsheet where cell A1 = the sum of the cells A2:K2
However I would like the sum to end anywhere before A11 depending on the row
number that the user enters.
So for exampe if they entered 5 in the specified cell then
A1 = Sum(A2: column 5 2)

I've trid R1C1 notation and that, but I can't get it to work.

Any ideas?

Many thanks in advance.

 

[Don Guillett]

=SUM(A2:OFFSET(A2,0,E7-1))