let me try it and get back to you. Thanks

"Max" wrote:

One way using SUMPRODUCT ..

Try something like this in say, B1:
=SUMPRODUCT((A1:A1005)*(A1:A100<25))

B1 returns the count of values within A1:A100
which are greater than 5 but less than 25

Note that entire col references cannot be used
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"compliance data" wrote:
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?