Bob's solution works fine.
What are you entering in B1 and B2? What error are you getting?
With 13 in B1 and 15 in B2 and the values 10,20,30 in cells A13, A14 and A15
I get the correct result of 60.

--
Regards
Roger Govier
"Russ" wrote in message
...

On Thu, 28 Jul 2005 16:06:46 +0100, "Bob Phillips"
wrote:

Perhaps you mean

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


I tried your solution but Excel didn't like it. I re-arranged the
quotes and ampersands but could not get it to go. Got any explanation
for this one?

Russ