Using COUNTIFS to compare data between 2 dates

[russ101]

I have all kinds of data and a lot of columns with lots of formulas to calculate different metrics, now I am concern with three columns of data particularly that I am trying to count to see how long a job in 01/25/2011 in category 4 took 3 hours to complete, and then another job in 02/21/2011 in category 3 took 5 hours to complete. So basically here is the data format.

A1. Any number between 1 - 10 (Categeories)
B1. Dates and Time -1/10/2011 14:48 (YTD Data)
C1. Duration - 6.30 Business hours (Came up from another formula)

So with some help wi was able to come up with the following formula

=COUNTIFS(B1:B5000,">="&"01/31/2011"+0,A10:A5000,3,C10:C5000,"<="&0.5) it works great but I would also like to get the data between 2 dates. For instance, if I am looking at the column of YTD data (01/01/2011 - 12/31/2011) and want to have a separate count for all of January (01/01/2011 to 01/31/2011), February (02/01/2011 to 02/28/2011), March etc. with the other criteria remains the same(A10:A5000,3,C10:C5000,"<="&0.5)

 

[Aladin Akyurek]

...

E2: 1-Jan-11

E3: 1-Feb-11

etc...

F2, enter and copy down:

=EOMONTH(E2,0)

G2, enter and copy down:

=COUNTIFS(
    $A$10:$A$5000,3,
    $B$10:$B$5000,">="&E2,
    $B$10:$B$5000,">="&F2,
    $C$10:$C$5000,"<=0.5")