*From*: "Andreas J. Guelzow" <aguelzow taliesin ca>*To*: gnumeric-list gnome org*Subject*: Re: Array formulas, piecewise functions*Date*: Thu, 15 Sep 2005 09:32:29 -0600

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

**Attachment:
signature.asc**

**References**:**Array formulas, piecewise functions***From:*Stephen R Laniel

**Re: Array formulas, piecewise functions***From:*Oliver Burnett-Hall

**Re: Array formulas, piecewise functions***From:*Stephen R Laniel

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