Re: Array formulas, piecewise functions



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



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