Hi all,

I have the following:

=SUMPRODUCT(--(MONTH(ServicesExcelExport!AH:AH)=11)*--(ServicesExcelExport!AJ:AJ=summary!B21)*--(ServicesExcelExport!F:F="Near Miss"))
AH:AH - a range of dates. Coutning those in Novemeber
AJ:AJ - a range of subjects, counting those that match the subjects in the table
F:F - a range of other subjects that includes Near Miss

The code is coming back with NA

Any thoughts?