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
