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]
