variable column

  • Thread starter Thread starter Libby
  • Start date Start date
L

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.
 
Back
Top