Hi,
I've been using excel for a long time. However i'm now learning a whole new level of it for my new job and i've hit a snag.
I need to know how many times the courier was on time.
This equation works well,
=COUNTIFS(Colours!$D3:$D7,">08:15",Colours!$D3:$D7,"<08:25")
However they have to arrive within a 10min window on lots of different times, for example,
=COUNTIFS(Colours!$F3:$F7,">09:15",Colours!$F3:$F7,"<09:25")
Instead of writing out the < and > times for each individual i was it to do it automatically when i drag down
I tried doing this by e.g. having
=COUNTIFS(Colours!$D3:$D7,">A1",Colours!$D3:$D7,"<B1")
=COUNTIFS(Colours!$F3:$F7,">A2",Colours!$F3:$F7,"<B2")
Then having a separate list those cells could correspond to which i could then hide later on. This would also make life easier if the courier times ever change in the future. However when ever i try that the result is always 0. What am i doing wrong? When ever i link cells else where it works fine.
Thank you in advance for any help it is really appreciated.
Holden
Bookmarks