Counting the number of times in a column certain date & time conditions are met

I have a spread sheet that contains dates in column A and times in column B and I wish to automatically count the number of times against each date that the time falls between two parameters. below is an example of the data.;
DATE TIME
29/06/2013 15:44
30/06/2013 15:20
30/06/2013 09:25
29/06/2013 13:45
28/06/2013 12:45
27/06/2013 07:50
29/06/2013 17:15
28/06/2013 11:20
30/06/2013 09:44
30/06/2013 10:50
30/06/2013 17:10
29/06/2013 11:50
29/06/2013 13:05
30/06/2013 10:35
30/06/2013 11:02
28/06/2013 11:40
29/06/2013 14:25
30/06/2013 11:40
30/06/2013 12:05
29/06/2013 13:47
30/06/2013 11:10
29/06/2013 17:20
29/06/2013 14:20
29/06/2013 19:05
30/06/2013 07:45
30/06/2013 10:04
30/06/2013 10:17
30/06/2013 14:02
30/06/2013 15:14

I need to count for each date the number of occurences that fall between the following time intervals

00:01-03:00 03:01-06:00 06:01-09:00 09:01-12:00 12:01-15:00 15:01-18:00 18:01-21:00 21:01-24:00

What would be the best formula to use. I have been trying " Countif" but cant get the syntax right.
Any help

Cheers

Assuming you have Date in Col. A from A2:A30 and Time in Col. B from B2:B30 then set the upper time intervals in Col. C from C2:C9 as 03:00,06:00,09:00........00:00 from C2:C9. Then select D2:D9 and in the active cell (D2) type the below formula and confirm it with Ctrl+Shift+Enter

Please Login or Register  to view this content.

The FREQUENCY function returns a frequency distribution as a vertical array. For a given set of values and a given set of bins (or intervals), a frequency distribution counts the number of values that occur in each interval.

The FREQUENCY function syntax is as follows:

FREQUENCY(data_array, bins_array)

The function returns the number of elements you specify in the data_array argument that fall within the intervals you specify in the bins_array argument.

For more information go through the following links...

http://support.microsoft.com/kb/100122

http://office.microsoft.com/en-in/ex...010342543.aspx

Here's a solution that takes date and time into account, building on sktneer's original suggestion.
With the dates in E1:N1 and times in D2:D10 (including a time of 0)

Select E2:E10 and enter in this array function
=IF($D2:$D10=0,"",FREQUENCY($B$2:$B$30+$A$2:$A$30,E$1+$D$2:$D$10))
Use CNTRL SHFT ENTER instead of ENTER and that formula E2:E10 with {} around them.
Then drag formula to the right. See attachment

Another way to achieve this using simple COUNTIF function. Try this.......

Please Login or Register  to view this content.

Please see the attached sheet.

Thanks ChemistB ! That means a lot to me because I got attention from a Forum Guru. Thank you so much for the appreciation. You simply made my day.