Re: Cell Indirect Reference Question



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





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]