Try this...

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

Entered in B28 and copied down to B33:

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

--
Biff
Microsoft Excel MVP


"Zakhary" wrote in message
...
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?

--
Thanks,
Zakhary