0
Undo
Votes
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?
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?
There are no replies made for this post yet.