Count Function

R

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
 
J

JE McGimpsey

One way:

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

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
 
Top