So im just making a fun spreadsheet for me and my friends.

Columns = friends names: (B1=Kev, C1=Jon, D1=Sam....)
Rows = ranks (A2=1st Place, A3=2nd Place, A4=3rd Place....)

Each person will fill in their column with their votes: (here is how it would look after everyone fills it out)
_____Kev__Jon___Sam____
1st___S____J_____S______
2nd___J____S_____K______
3rd___K____K_____J______


I want column F to produce a list of the group consensus (calculations could be something like 3points for 1st, 2points for 2nd, 1point for 3rd)
Sam has 2 First, 1 Second, 0 Third = 8points
Jon has 1 First, 1 Second, 1 Third = 6 points
Kev has 0 First, 1 Second, 2 Third = 4 points

This is how it should look after the calculations
_____Kev__Jon___Sam_______Consensus__
1st___S____J_____S___________Sam_____
2nd___J____S_____K___________Jon______
3rd___K____K_____J___________Kev______