=SUM(INDIRECT("A"&B1&":A"&B2))

--
Regards,
Dave


"Tightlines" wrote:

Thanks,

That helped - how would it work if I wanted to make both of the references
in the formula using the INDIRECT function? (so I would have A1 determined by
a value in B1 and A10 determined by a value in B2)?

"Tightlines" wrote:

I'm trying to determine how I can easily change a cell reference in a formula
to a different value based on a calculation in my spreadsheet.

For example:

I have the formula Sum(A1:A10)

In reality, I would like the formula to change depending on the value in
another cell (say cell B1) so that when B1 = 54, the formula becomes
Sum(A1:A54). Is there a way I can change the reference in the formula in
this manner using cell values or constants?