Count specific numbers in a column
 

Hi,

Is there a way to count specific numbers in a column and enter the number
into a new cell.

For example:

A B C D
1 1 1 2 3
2 1 2 3 4
3 2
4 2
5 2
6 3
7 3
8 3
9 3

Column A is the data, in B2 I want a function that counts the number of "1"s
in column A, in C2 the same function that counts the number of "2"s in A,
and so on. I am in need of the function.

Thanks in advance.

Marc

Count specific numbers in a column
 

in B2 enter
=COUNTIF($A1:$A100,B1)

HTH

"JimmyH" wrote:

Hi,

Is there a way to count specific numbers in a column and enter the number
into a new cell.

For example:

A B C D
1 1 1 2 3
2 1 2 3 4
3 2
4 2
5 2
6 3
7 3
8 3
9 3

Column A is the data, in B2 I want a function that counts the number of "1"s
in column A, in C2 the same function that counts the number of "2"s in A,
and so on. I am in need of the function.

Thanks in advance.

Marc

Count specific numbers in a column
 

+COUNTIF(A1:A9,B1)


"JimmyH" wrote in message
news:aooyd.563758$nl.272435@pd7tw3no...
Hi,

Is there a way to count specific numbers in a column and enter the number
into a new cell.

For example:

A B C D
1 1 1 2 3
2 1 2 3 4
3 2
4 2
5 2
6 3
7 3
8 3
9 3

Column A is the data, in B2 I want a function that counts the number of
"1"s in column A, in C2 the same function that counts the number of "2"s
in A, and so on. I am in need of the function.

Thanks in advance.

Marc

Count specific numbers in a column
 

"Jim Thomlinson"

=COUNTIF($A1:$A100,B1)

Perfecto. Thanks!