Breaking ties in excel ranking

Excellent thanks BSB. Your countif assisted me and it worked.

I was wondering if I could bother you with another issue. Calls are scored on a daily basis using a call evaluation sheet.
I looked at it and see that the N/A affects the overall score either inflating or deflating it.
Is there any way to leave the ability to choose N/A without it affecting the score.
Currently the assessors simply choose "yes" to solve the problem if it is N/A.
I'm not comfortable with this at all as it isn't a true reflection of department performance.

Thank you

Jennifer