See if this thread and its links helps, if not post a sample workbook.
can a "MINIF" formula be built, equivalent to "SUMIFS"?

The formulae work for 2003
The last post has an example 2003 workbook