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