Forget about the column named Jan or use if if desired since it is just a
format of the date and therefore the same. so us

=SUMPRODUCT(--('PO LIST'!H3:H88="Calibration"),--(month('PO
LIST'!E3:E88)="Jan"),('PO LIST'!C3:C88))


--
Don Guillett
SalesAid Software

"SMac" wrote in message
...
I used the following formula:
=SUMPRODUCT(--('PO LIST'!H3:H88="Calibration"),--('PO
LIST'!E3:E88="Jan"),('PO LIST'!C3:C88))

The first part looks for "Calibration", then I need it to look for the
month
"Jan" and when it finds those two to calculate C3:C88.

I think my issue is with the field "MONTH" that contains a formated versus
("Jan"), off the column next to it with "DATE" i.e. 01/05/04 - is it not
recoginizning "Jan" as a word or does it still look at this field as a
date,
if so how do I enter criteria.

Your help is much appreciated!!

Thanks, Stacey