Thread: Count function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Count function

Try this:

=COUNTIF(C2:C10,81)

Biff

"L.T." wrote in message
...
Hi everyone, I am not good at explaination, so if you can understand what
I
am saying it is ok.
I am looking for a function that can count the number of time appear each
number in the column C
for example, there are two "81" in column C, if I type in the function
that
will be appear "2" in the cell.

A B C
Date Time Dest TM
15-Jan 20:00 81
15-Jan 23:45 51
15-Jan 0:30 22
15-Jan 16:00 22
16-Jan 20:00 81
16-Jan 23:45 51
16-Jan 0:30 22
16-Jan 16:00 22
16-Jan 17:40 51

Thank You