Thread: How do I count the frequency of a given number in a column?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Anne Troy
 
Posts: n/a
Default How do I count the frequency of a given number in a column?
=COUNTIF(C4:C7,"=1")
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

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


Reply With QuoteReply With Quote