Re: Cell Indirect Reference Question

["Jason A. Pfeil" <jason jasonpfeil com>]

Sweet!  Thanks, Morten.

I had assumed that the & operator was similar to the & (address-of)
operator in C or the @ (address-of) operator in pascal.  Rather, it
seems that & is an "and"-type concatenation operator used to build
strings.

Thanks for your help and patience.

Have an excellent weekend!

--Jason

On Fri, 2005-06-10 at 14:54 -0400, Morten Welinder wrote:
> On 6/10/05, Jason A. Pfeil <jason jasonpfeil com> wrote:
> > Morten,
> >
> > How about if I wanted the starting part of the range to be indirect as
> > well?  Such as the below.
> >
> > =sumif(indirect("$D"&$I$3":$D"&$I$4),"="&$H6,indirect("$B$1:$B$"&$I$4))
>
> INDIRECT doesn't care where the string comes from, but it looks like you
> are missing an "&" before quote-colon.
>
> Morten
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list