There are several ways of doing this....

A nice simple one is to use the countif function. If you calculate the
number of times a threshold is exceeded for two different thresholds,
the number between is simply the difference between the two

e.g. =countif("A1:A4600","0")-countif("A1:A4600","0.5")

will give you the count 0 and <= 0.5


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=558202