*From*: Oliver Burnett-Hall <olly burnett-hall co uk>*To*: gnumeric-list gnome org*Subject*: Re: Array formulas, piecewise functions*Date*: Thu, 15 Sep 2005 19:00:36 +0100

Stephen R Laniel wrote:

On Thu, Sep 15, 2005 at 06:34:50PM +0100, Oliver Burnett-Hall wrote:=sum(if(and($g$2:$g$30000>=h2,$g$2:$g$30000<h3),1,0))[snip]Have you tested that formula in Excel? I'd be very surprised if it worked.I've not tested it. But it does seem syntactically valid, right? If not, where did I mess up the syntax?

You've got it inside out.

I don't think the final result is the one you were looking for :) - olly

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

**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]