count the occurence of number in a column
 

hi,
may i ask: how do i count the occurence of a number in a column? an example:

1
5
8
1
3
4
1
5
1


occurence of 1 = 4
occurence of 3 = 1
occurence of 4 = 1
occurence of 5 = 2
occurence of 8 = 1

what would be the formula for that in excel, please? i have no clue at all.
i tried google and it came up with something but i could not really find the
answer to my question.
tks,

l.

count the occurence of number in a column
 

Hi
=COUNTIF(A:A,1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Laura" schrieb im Newsbeitrag
...
hi,
may i ask: how do i count the occurence of a number in a column? an
example:

1
5
8
1
3
4
1
5
1


occurence of 1 = 4
occurence of 3 = 1
occurence of 4 = 1
occurence of 5 = 2
occurence of 8 = 1

what would be the formula for that in excel, please? i have no clue
at all.
i tried google and it came up with something but i could not really
find the
answer to my question.
tks,

l.