How do I count the frequency of a given number in a column?
Try something like this:
For numbers in A1:A10
B1: =COUNTIF(A1:A10,1)
(Returns the count of 1's)
or
C1: (a number between 1 and 5)
B1: =COUNTIF(A1:A10,C1)
(Returns to the count of items that match the value in C1)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"dykstra_sj" wrote:
In a column I have a list of numbers (1-5) and I want to know how many 1s,
2s, 3s, etc. What is the formula?
|