Hi I have transposed what you have done to the actual sheet it now looks like this

=IF(SUMPRODUCT(('July Scores'!$A$2:$A$1650=$A5)*('July Scores'!$BV$2:$BV$1650=$R$2)),"",MAX(IF('July Scores'!$A$2:$A$1650=$A$3,IF('July Scores'!$BV$2:$BV$1650=$R$3,'July Scores'!$BY$2:$BY$1650))))

Something is working because where I have "checked cases" (i.e. a number in the check field) the field is blank as per your example, where there is a no cases checked i am returning 0 on all Mr's

I have entered the forumal as an array

Thanks