Hi All,

Is there a way to look at a date and only use the month in the criteria. I
was trying to use the code below

Thanks for any help


=SUMPRODUCT((tblProcessorActivity!B1:B30000="CG")* (MONTH(tblProcessorActivity!C1:C30000)=MONTH(MAX(t blProcessorActivity!C:C)))*(tblProcessorActivity!N 1:N30000=4),tblProcessorActivity!D1:D30000)