Specifying a range using cell values

[brad <brad fortunet com>]

I'm trying to sum a range of cells, but I want to use cell values to 
specify what range to sum.

I've tried:

sum(address(A1,2):address(A2,2))

but this only gives me a syntax error.  I've also looked at the offset 
function, but I can't find any examples and I have yet to construct an 
offset statement that doesn't result in a syntax error.

Thanks for the help,
Brad