Try either:

=SUMPRODUCT((B5:B33124)*(B5:B33<150))

or:

=COUNTIF(B5:B33,""&124)-COUNTIF(B5:B33,"="&150)

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"ChrisC" wrote in message
...
How do I count the number of times a number is between two numbers?

range of cells is B5:B33
would like to know how many times a number shows up that is 124 but <150