Hello people!
First time posting here, and I've hit a bit of a hard wall.
I have a column containing days of the week Mon-Sun, and another column containing specific times of when a particular event occurs.
e.g.
Column A | Column B
Tuesday | 15:23
Thursday | 10:18
Wednesday | 21:46
Tuesday | 15:02
Monday | 03:15
Friday | 19:08
Tuesday | 09:51
What I'm trying to generate is a formula that can look at both column A and column B, and count how many times on a Tuesday did the event take place between 15:00 and 15:59, (in the above example the outcome of this sought-after formula would be 2), and I don't know how to do it
Any help would be thoroughly appreciated!
Thank you so much
Bookmarks