in sheet Injury Register I have:
Dates in column C dd/mm/yyyy c2:c125
Column I drop down list with FAI, LTI, MTI and RO I2:I125

In sheet Dashboard, I want
to count all FAI in July, MTI in July ....etc

I am using this formular
=SUMPRODUCT(('Injury Register'!$I$2:$I$41=Dashboard!A$12)*(MONTH('Injury Register'!$C$2:$C$50)=7))

Cell A12 is LTI
7 is month July

This is giving me error. Can you please help?