Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 06, 07:29 PM posted to microsoft.public.excel.newusers
dykstra_sj
 
Posts: n/a
Default How do I count the frequency of a given number in a column?

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?

  #2   Report Post  
Old February 2nd 06, 07:37 PM 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?

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?

  #3   Report Post  
Old February 2nd 06, 07:38 PM 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?



  #4   Report Post  
Old February 2nd 06, 08:11 PM posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default 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 (1-5) and I want to know how many 1s,
2s, 3s, etc. What is the formula?


  #5   Report Post  
Old February 2nd 06, 08:19 PM 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?

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?





  #6   Report Post  
Old February 2nd 06, 08:25 PM posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default 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 (1-5) and I want to know how many 1s,
2s, 3s, etc. What is the formula?

  #7   Report Post  
Old February 2nd 06, 08:32 PM 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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Count Intervals of 1 Numeric value in a Row and Return Count down Column Sam via OfficeKB.com Excel Worksheet Functions 8 October 4th 05 04:37 PM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017