In another column insert the test formula: =AND(A1250, A1<2000), then count
the number of cells in that column containing TRUE.





"WBTKbeezy" wrote in message
...
I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?