Another way:

=SUM(INDEX(A:A,B1):INDEX(A:A,B2))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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