Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count function
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count function
COUNTIF?
L.T. wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count function
COUNTIF?
L.T. wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count function
You want Countif, as in:
=COUNTIF(C:C,81) -- Regards, Fred "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
Count Function | Excel Worksheet Functions | |||
How do I add the count function to the toolbar? | Excel Worksheet Functions | |||
Can I count in an array based on a function? | Excel Worksheet Functions |