View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default How do I count the frequency of a given number in a column?

I seem constantly to be learning here...<<

I think every one of us feels the same way.
I know I do.
***********
Regards,
Ron

XL2002, WinXP-Pro


"Anne Troy" wrote:

Thanks, Ron. I seem constantly to be learning here...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

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