Trouble with COUNTIFS() formula

I have a table that is formatted as so:

PHP Code: 

    A           B                  C                     D
1 Type    Timeinitial    Time ending           Total Time    
2   8                                                  00:00            
3   8                                                 00:00            
4   5    7/29/2012 8:37    7/29/2012 8:55            00:18    
5   5    8/4/2012 12:57    8/4/2012 13:06             00:09 


There are a lot more rows below Row 5....

I am trying to count each row where Type = 5, the total time is >00:00 and the month is August

I wrote the following formula:

=COUNTIFS(A2:A5, "5",D2:D5, ">00:00",C2:C5="mmmyyyy", "Aug2012")

I keep getting a num error...any help of this formulate is deeply appreciated!

Try it like this...

=SUMPRODUCT(--(A2:A5=5),--(D2:D5>0),--(TEXT(C2:C5,"mmmyyyy")="Aug2012"))

Based on the posted sample data I get the correct result of 1.

Post the exact formula that you are using.

All of the ranges need to be the same size.

Column D starts on row 3, D3, while columns AB and M start on row 2, AB2 and M2.

--(TEXT(C2:C5,"mmmyyyy")="Aug2012")

That's testng to see if the dates in column C, when formatted as text strings in the format mmmyyyy (short month name followed by the 4 digit year number), equal the text string Aug2012.

Examples:

C4 = 7/29/2012 8:55 = (TEXT(C4,"mmmyyyy") = Jul2012
C5 = 8/4/2012 13:06 = (TEXT(C5,"mmmyyyy") = Aug2012

It was OK up to this point:

=COUNTIFS(A2:A5, "5",D2:D5, ">00:00",...

The COUNTIFS function can only do straight comparisons. It can not take arguments that "manipulate" the range references which is what (TEXT(C2:C5,"mmmyyyy")="Aug2012") does.

You're welcome. Thanks for the feedback!