Try:

=COUNTIF(A:A, "<=" & A2)-COUNTIF(A:A, "<" & A2-5)

"Rikuk" wrote:


Thanks that works great

Can you tell how many are within a range of a number say 5 lower

ie
80 How many between 80 & 75
70 how many between 70 & 65


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=546671