Count specific numbers in a column

[JimmyH]

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

 

[Guest]

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

HTH

 

[Ev]

+COUNTIF(A1:A9,B1)

 

[JimmyH]

"Jim Thomlinson"

=COUNTIF($A1:$A100,B1)

Perfecto. Thanks!