Home 
Search 
Today's Posts 
#1




How do I count the frequency of a given number in a column?
In a column I have a list of numbers (15) and I want to know how many 1s,
2s, 3s, etc. What is the formula? 
#2




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, WinXPPro "dykstra_sj" wrote: In a column I have a list of numbers (15) and I want to know how many 1s, 2s, 3s, etc. What is the formula? 
#3




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 (15) and I want to know how many 1s, 2s, 3s, etc. What is the formula? 
#4




How do I count the frequency of a given number in a column?
One more methos.
Assuming your digits are in A1:A100 In B1:B5 enter digits 1 through 5. Select C1:C5 In activecell C1 enter =FREQUENCY(A1:A100,B1:B5) and hit CTRL + SHIFT + ENTER Excel will place curly brackets around the formula because it is an ARRAY formula. The frequency of each number in B1:B1 will be returned to C1:C5 Gord Dibben MS Excel MVP On Thu, 2 Feb 2006 11:29:32 0800, "dykstra_sj" wrote: In a column I have a list of numbers (15) and I want to know how many 1s, 2s, 3s, etc. What is the formula? 
#5




How do I count the frequency of a given number in a column?
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, WinXPPro "dykstra_sj" wrote: In a column I have a list of numbers (15) and I want to know how many 1s, 2s, 3s, etc. What is the formula? 
#6




How do I count the frequency of a given number in a column?
Check out Tools DataAnalysis Histogram.......
Vaya con Dios, Chuck, CABGx3 "dykstra_sj" wrote: In a column I have a list of numbers (15) and I want to know how many 1s, 2s, 3s, etc. What is the formula? 
#7




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, WinXPPro "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, WinXPPro "dykstra_sj" wrote: In a column I have a list of numbers (15) and I want to know how many 1s, 2s, 3s, etc. What is the formula? 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Need to Improve Code Copying/Pasting Between Workbooks  Excel Discussion (Misc queries)  
Positioning Numeric Values Resulting from 6 Column Array Formula  Excel Worksheet Functions  
creating a bar graph  Excel Discussion (Misc queries)  
Count Intervals of 1 Numeric value in a Row and Return Count down Column  Excel Worksheet Functions  
Count Position of Filtered TEXT cells in a column  Excel Worksheet Functions 