If your numbers are all greater than or equal to zero and in range
A1:A10
=COUNTIF(A1:A10,"<=40")
If the above formula is in B1 then for 41-80
=COUNTIF(A1:A10,"<=80")-B1
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=504465