Assuming the A1:A100 is your data.
B1 = '-5 to -4
B2 = '-4 to -3
B3 = '-3 to -2
B4 = '-2 to -1
B5 = '-1 to 0
B6 = '0 to 1
B7 = '1 to 2
B8 = '2 to 3
B9 = '3 to 4
C1 = =COUNTIF(A1:A100,"-5")-COUNTIF(A1:A100,"-4")
C2 = =COUNTIF(A1:A100,"-4")-COUNTIF(A1:A100,"-3")
C3 = =COUNTIF(A1:A100,"-3")-COUNTIF(A1:A100,"-2")
C4 = =COUNTIF(A1:A100,"-2")-COUNTIF(A1:A100,"-1")
C5 = =COUNTIF(A1:A100,"-1")-COUNTIF(A1:A100,"0")
C6 = =COUNTIF(A1:A100,"0")-COUNTIF(A1:A100,"1")
C7 = =COUNTIF(A1:A100,"1")-COUNTIF(A1:A100,"2")
C8 = =COUNTIF(A1:A100,"2")-COUNTIF(A1:A100,"3")
C9 = =COUNTIF(A1:A100,"3")-COUNTIF(A1:A100,"4")
Hope that helps
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=551085