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