You could have posted an example of the formula in question.

However, as an example:

=SUM(A1:A10)

Cell references for start and end of Sum() range are in B1 and C1.

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

Alternate formula:

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

--

HTH,

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

"ArthurN" wrote in message
...
Once I posted a question if I could reference the cell dynamically when the
reference equals some other cell value, for example, and some nice people
here advised me to use the "indirect" function, which worked perfectly for
me
and made me happy until I discovered this function missing on my PDA running
Windows 2003 SE. Is there some workaround? I'm getting so desperate...