This what I am looking to do. My data source is a SQL database.

I have a query with three fields. I want to get counts on three criteria, I
have the two working find, now need the date.
=SUMPRODUCT((Sheet1!$A$2:$A$10000 = $A6) * (Sheet1!$D$2:$D$10000 = "EMAIL"))
This works fine.

The other field from Sheet1 that I want to check is a date field in the
following format.

6/15/2005 9:13


I want my report to be monthly, so I would like it check for $A6 and EMAIL
above and in my example, month of June data only.
Something like Month(data from Sheet1) = 6. I really don't want to use a
helper column if not necessary.

=SUMPRODUCT((Sheet1!$A$2:$A$10000 = $A6) * (Sheet1!$D$2:$D$10000 = "EMAIL")
* (Sheet1$C$2:$C$1000 = MONTH( not sure after this)

Thanks