Question about Sum
 

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

Question about Sum
 

Put this formula
=SUM(INDIRECT("B"&A1):B50)

Question about Sum
 

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.

--
Biff
Microsoft Excel MVP


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