Counting the number of occurrences...

[Zakhary]

If I have a range (B3:B27) that contains number values between 0 and 5, and I
want to count the number of times each of those values occurs in that range,
what formula can I use...

In cell B28, I want the total number of instances that "5" occurs in the
range (B3:B27); In cell B29, I want the total number of instabnces that "4"
occurs in the range (B3:B27); and so on.

What formlua performs this task?

 

[Kassie]

Use COUNTIF

=COUNTIF(B3:B27,5) to count the 5's
=COUNTIF(B3:B27,4) to count the 4's and so on

--
HTH

Kassie

Replace xxx with hotmail

 

[T. Valko]

Try this...

A28:A33 = 5,4,3,2,1,0

Entered in B28 and copied down to B33:

=COUNTIF(B$3:B$27,A28)