Question about Sum

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Hello,
In the formula =sum(B6:B50) is there any to make the value represented
here by the “6†a variable? Is there any I could point it to, say, the value
in cell “A1�

Thank you,

Keith
 
Try this:

A1 = 6

=SUM(INDEX(B1:B50,A1):B50)

If A1 is an empty cell the formula will calculate the entire range. If A1 is
a number >50 then you'll get a #REF! error.
 
Back
Top