I have a table that is formatted as so:
There are a lot more rows below Row 5....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
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!
Bookmarks