Re: Specifying a range using cell values

[Jody Goldberg <jody gnome org>]

On Fri, Jun 25, 2004 at 11:38:52AM -0700, brad wrote:
> 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.

address returns the range as a string.
Pass that into OFFSET