Counting the number of occurrences...
 

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

Counting the number of occurrences...
 

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


"Zakhary" wrote:

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

Counting the number of occurrences...
 

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