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!

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!

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!

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!

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!

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!

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!