Count Function

[Rikuk]

I have a colum of numbers ranging for 0 to 100, for each row I need to
know

how many are the same value
how many are a higher value
how many are a lower value

Is there a easy way of doing this?

ie
rate same higher lower
80 1 1 2
50 0 4 0
55 0 3 1
80 1 1 2
90 0 0 4

 

[JE McGimpsey]

One way:

B2: =COUNTIF(A:A, A2) - 1
C2: =COUNTIF(A:A, ">" & A2)
D2: =COUNTIF(A:A, "<" & A2)

 

[Rikuk]

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

 

[Guest]

Try:

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