Formula to count occurances in a given date range

[thaithco]

I am needing to count the number of calls in a call center between certain hours by date. Column A is the date, Column B is the time of the call. I am needing to know how many calls occurred on X date between the hours of y and z. I have tried various forms of the countif and sumproduct but can't seem to get any of them to work for me. Here is the graph I am trying to populate:


Date Hours
12a-4a 4a-8a 8a-12p 12p-4p 4p-8p 8p-12a
12-7-09
12-8-09
12-9-09
12-10-09
12-11-09

Any help will save me my job...just kidding but it would be greatly appreciated.

 

[thaithco]

Thanks to all who helped with my issue...the isnumber and sumproduct help was wonderful. Thanks again.

Tom