How to count date as a criteria in countifs

Hiya - reading your post and looking at your spreadsheet I am not totally clear as to what it is you want to achieve.

Could you add further details?

You can use a SUMPRODUCT formula.

Or maybe you would be better off with a pivot table.

Edit - lol I see there is alot of action already,,,,,,,,,,, Hi Andy!

hiya - got it.

Just popping out now but will post back with something within a couple of hours.

You can group by month and then uncheck the blank row.

Or as in my example I used the ThisMonth filter which automatically excluded the blanks.

Acutally the blank dates will impact on the formula provided as the blanks will be included in January month.
So the sumproduct would need a test for non blanks

=SUMPRODUCT((A2:A15=G2)*(B2:B15=G3)*(C2:C15=G4)*(MONTH(D2:D15)=MONTH(G5))*(D2:D15<>""))

Here's another approach using Data Validation, a Helper Column(E) whch can be hidden, and COUNTIFS as you are using 2007.

Select from the drop-Downs H2:H5

To see the Lookups and Helper Column toggle the Grouping Buttons +/- below the formula bar.

Hope this helps