Bob Long wrote:
Simpler:=COUNTIF(range;">5")-COUNTIF(range;">=10")
And another one: =SUMPRODUCT(range>5;range>=10) --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org