Use two COUNTIFs.

=COUNTIF(A1:A10,"<=9")-COUNTIF(A1:A10,"<5")

This will return the count of numbers in A1:A10 that are between 5 and 9.
Change the "<" and "<=" comparison operators to fit your needs.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"compliance data" <compliance wrote in
message ...
I need to find the number of cells in a column that are greater than value
x
and less than value y.

I ahve tried vairations of punctuation spacing etc. with no luck. I am
beginning that it is not possible.

Anyone have any ideas?