That worked like a champ.
Thanks, Morten!
Have a great day!
--Jason
On Fri, 2005-06-10 at 12:46 -0400, Morten Welinder wrote:
> > =sumif($D$1:$D&INDIRECT('G3'),"="&$F5,$B$1:$B$296)
>
> You need to put the whole range into indirect.
>
> =sumif(INDIRECT("d1:d"&g3),...)
>
> Note, that "d1" is now inside a string and therefore will not change
> if you insert
> or delete a column.
>
> 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
