Re: Cell Indirect Reference Question

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

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))

Gnumeric doesn't appear to like splitting the range in that manner.  Is
that possible and I am just doing it wrong, or am I trying to do
something that gnumeric can't do?

Thanks!

--Jason

On Fri, 2005-06-10 at 14:14 -0400, Jason A. Pfeil wrote:
> 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
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list