A question of range

  • Thread starter Thread starter McGoo
  • Start date Start date
M

McGoo

Dear Group,
I cannot think of how to do this:

Say A1:A5 contain numerals. B1 contains a numeral, say 6. C1
contains =SUM(A1:A5).

Instead if summing the range down to A5, can I rewrite the formula in
C1 to use the numeral in B1 as the second of the range?
ie. C1 contains =SUM(A1:A (the numeral in B1)).

Thanks for any assistance.
McGoo
 
Back
Top