Re: Array formulas, piecewise functions

[Oliver Burnett-Hall <olly burnett-hall co uk>]

Stephen R Laniel wrote:
> On Wed, Sep 14, 2005 at 06:43:59PM +0100, Oliver Burnett-Hall wrote:
> Why doesn't
>
> =sum(if(and($g$2:$g$30000>=h2,$g$2:$g$30000<h3),1,0))
>
> work? It should, right?

Have you tested that formula in Excel?  I'd be very surprised if it worked.

- olly