Try this:

=SUMPRODUCT((range="x")*(MONTH(range)=5))

Don't forget the parentheses!!

Assumes dates are in Excel date format.

Hope this helps.

Pete

On Oct 9, 12:14 am, Coley wrote:
I can't seem to make SUMPRODUCT work with a date field as a criteria.

SUMPRODUCT(range="x")*(range="9/1/07")
I would like for the date range to look for "*/5/*" ie. amy month, any year.
If I change the range and look for words in that range it works. I just
can't seem to get it to work with a date.