Re: Cell Indirect Reference Question

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

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
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list