On Fri, 2010-02-19 at 12:32 +0100, Andreas Saeger wrote:
> Bob Long wrote:
> 
> > Simpler:
> > 
> > =COUNTIF(range;">5")-COUNTIF(range;">=10")
> > 
> 
> And another one:
> =SUMPRODUCT(range>5;range>=10)
> 
> 

sumproduct worked perfect, thanks!

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to