Adding countif formula. Is there a better way?

Hi All, In the attached workbook I have a formula in P3 that returns the correct result, its looking for how many times a person has the highest score in each column. I have a MAX formula in Row 53 to help.

=COUNTIF(C3,C53)+COUNTIF(D3,D53)+COUNTIF(E3,E53)+COUNTIF(F3,F53)+COUNTIF(G3,G53)+COUNTIF(H3,H53)+COUNTIF(I3,I53)+COUNTIF(J3,J53)+COUNTIF(K3,K53)+COUNTIF(L3,L53)+COUNTIF(M3,M53)++COUNTIF(N3,N53)

I'm just wondering if there is a better way of doing this?

As always, any suggestions are much appreciated.

Why do you have ++ at the end of that formula?

Try this:

=SUMPRODUCT((C3:N3<>"")*(C3:N3=C$53:N$53))

Thanks for the rep.

I was talking to a friend in the East Midlands whose club's course has been underwater for weeks. He says it's costing them more in maintenance than normal, yet the members are demanding refunds!!!

I can well imagine that you have a lot of inefficient formulae, Marvo.