I am trying to incorporate two functions into one cell. I have the day in one column and time in another column
Day Time
14 8:01
14 8:05
14 9:06
15 8:50
15 8:02
16 2:00
16 2:50
e.g I want to find the number of times day 14 occurs between 8:00 and 9:00. The answer I would be looking for is 2 in this case. I have tried putting in the countif function along with "and" to separate the second function, but it doesn't work. Any suggestions?
Day Time
14 8:01
14 8:05
14 9:06
15 8:50
15 8:02
16 2:00
16 2:50
e.g I want to find the number of times day 14 occurs between 8:00 and 9:00. The answer I would be looking for is 2 in this case. I have tried putting in the countif function along with "and" to separate the second function, but it doesn't work. Any suggestions?