creating a leaderboard

Hi all, i am not the greatest with excel and i am trying to create a leaderboard in excel from data i input.
Looks something like this:
Column A Column B Column C
A. Smith B. Jones C. Brown
D. Johns E.Bryan F. Ball

And so on.....the people in column a have been awarded 3 votes for there perfomance, the people in column b get 2 votes and the people in column c get 3 votes.
Obviously some people will score a number of times in different columns as well.

Does anyone know how to create a leaderboard from this information?

Cheers.