In the interim while awaiting Chip's response, some thoughts ..

Did you use something like:
=COUNTIF(A:A,"<2")-COUNTIF(A:A,"<=0.5")

If so, and you're not getting the correct results, then possibly
there's some source numbers which are text numbers, not real numbers.
In which case, you could do this to convert the entire col to real
numbers. Select an empty cell, copy it, then select col A, right-click
paste special Check "Add" OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
compliance data wrote:
Tried it this morning and it did not work. I was looking for values .5 and
<2.0. for this particular data set there are 76 cells in the column. 3 cells
were =2.0 and 72 were <=.5. The answer should have been 1 got 69??