| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count the number of each number in a column?
I have columns containing numbers 1-6 (randomly). At the bottom, I do not
want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of each number in a column?
=COUNTIF(A2:A10,2)
to count 2's as long as they are the only number in the cell -- Regards, Peo Sjoblom "Shelby" wrote in message ... I have columns containing numbers 1-6 (randomly). At the bottom, I do not want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of each number in a column?
Put 1 to 6 in cells A101 to A106 (say), then in B101 you can put this
formula: =COUNTIF(B$1:B$100,$A101) You may need to adjust the ranges and cell references to suit your data, but you can then copy the formula into B102:B106, and then copy these 6 formulae across to other columns. Hope this helps. Pete On Sep 27, 12:11*am, Shelby wrote: I have columns containing numbers 1-6 (randomly). At the bottom, I do not want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of each number in a column?
Thank you so much...very useful!
"Peo Sjoblom" wrote: =COUNTIF(A2:A10,2) to count 2's as long as they are the only number in the cell -- Regards, Peo Sjoblom "Shelby" wrote in message ... I have columns containing numbers 1-6 (randomly). At the bottom, I do not want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of each number in a column?
So kind of you to help out...just the job!
"Pete_UK" wrote: Put 1 to 6 in cells A101 to A106 (say), then in B101 you can put this formula: =COUNTIF(B$1:B$100,$A101) You may need to adjust the ranges and cell references to suit your data, but you can then copy the formula into B102:B106, and then copy these 6 formulae across to other columns. Hope this helps. Pete On Sep 27, 12:11 am, Shelby wrote: I have columns containing numbers 1-6 (randomly). At the bottom, I do not want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of each number in a column?
Is there also a way that I could find out how many of the numbers are more
than 2, more than 3, more than 4, etc? Thanks, Shelby "Peo Sjoblom" wrote: =COUNTIF(A2:A10,2) to count 2's as long as they are the only number in the cell -- Regards, Peo Sjoblom "Shelby" wrote in message ... I have columns containing numbers 1-6 (randomly). At the bottom, I do not want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of each number in a column?
Try looking at Excel help for the COUNTIF function.
-- David Biddulph "Shelby" wrote in message ... Is there also a way that I could find out how many of the numbers are more than 2, more than 3, more than 4, etc? Thanks, Shelby "Peo Sjoblom" wrote: =COUNTIF(A2:A10,2) to count 2's as long as they are the only number in the cell -- Regards, Peo Sjoblom "Shelby" wrote in message ... I have columns containing numbers 1-6 (randomly). At the bottom, I do not want to total, rather I wish to count up how many 1s, how many 2s, how many 3s etc. I know there must be a way, but I can't see the wood for the trees! Any help will be gratefully accepted. Confused of Lichfield! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count to find the number of 100% 90% 80% in a column | Excel Discussion (Misc queries) | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Count the number of names in a column | Excel Worksheet Functions | |||
| count number of text in a column | Excel Discussion (Misc queries) | |||
| How can I count the number of entries in a column? | New Users to Excel | |||
Linear Mode
