Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif - Counting time in a Column
I am trying to count the occurances of time in a column e.g how many calls
were received between 07:00:00 and 17:0:00 Does anyone know a formula that works for time? |
#2
|
|||
|
|||
Hi,
Supposing that the time data are in A2....A100, to count the number of calls that were received between 07:00:00 (enter this B2) and 17:00:00 (enter this in C2), and in D2 enter the following formula and click Enter. =SUMPRODUCT((A2:A100=B2)*(A2:A100<=C2)) Regards, B. R. Ramachandran "TRM" wrote: I am trying to count the occurances of time in a column e.g how many calls were received between 07:00:00 and 17:0:00 Does anyone know a formula that works for time? |
#3
|
|||
|
|||
Here's another version:
=SUMPRODUCT(--(A1:A22=TIME(7,0,0)),--(A1:A22<=TIME(17,0,0))) -- tj "TRM" wrote: I am trying to count the occurances of time in a column e.g how many calls were received between 07:00:00 and 17:0:00 Does anyone know a formula that works for time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting item in a column | Excel Discussion (Misc queries) | |||
Counting States basied on the time and date stamp | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Excel: Add time to a date and time column? | Excel Worksheet Functions | |||
Time axis column and scatter/line graph | Charts and Charting in Excel |