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
> > [email protected]
> > http://mail.gnome.org/mailman/listinfo/gnumeric-list
> >
>
> _______________________________________________
> 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
