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 <[EMAIL PROTECTED]> 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
> [email protected]
> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
