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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Libby" wrote in message
...
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.