Question about Sum

[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

 

[Vijay]

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

 

[T. Valko]

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.