On Thu, 2005-15-09 at 11:03 -0400, Stephen R Laniel wrote: > On Wed, Sep 14, 2005 at 06:43:59PM +0100, Oliver Burnett-Hall wrote: > > =SUM(($G$2:$G$30000>=H2)*($G$2:$G$30000<H3)) > > > > This works in Excel too. > > I completely forgot about that approach, but it works great. > Thanks so much for reminding me of it. > > Why doesn't > > =sum(if(and($g$2:$g$30000>=h2,$g$2:$g$30000<h3),1,0)) > > work? It should, right?
It should work, but not as you may expect. In this you could also drop the "sum" since the "and" applies to all 59998 inequalities I would think. Andreas -- Andreas J. Guelzow, Professor Dept. of Mathematical & Computing Sciences Concordia University College of Alberta
signature.asc
Description: This is a digitally signed message part
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
