Use two COUNTIF functions. E.g.,

=COUNTIF(A1:A10,"<100")-COUNTIF(A1:A10,"<90")



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jsky" wrote in message
...
how can I use the COUNTIF formula to count only those numbers
that fit
between a range like greater than 90 but less than 100.