making a bowling league table

[ahsan88]

I have been trying to do this for a while know but cannot figure this out. Someone please help:

Rank	Player	Played	pts	Total Points
	Tariq			2475
	Major			2577
	Ahsan			2528
	Saad			2139

<colgroup><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>

This is a ranking table that I am trying to make.
For every match the winner gets 10 pts, 2nd place gets 7pts, thrid gets 5pts and last gets 2pts. The person with the highest score wins the match. I want to be able to see automatic ranking changes as I enter a new games scores, also want to see there total points and total scores, If there is a tie in points than the person with the higher score takes the position. there are 32 matches in the league in total.

 

[iyyi]

If you have the Rank in column A, the Player in B, the Total Points in C and in columns D to AI you have the matches scores, e.g 1 for the winner, 2 for the second, 3 for the third and 4 for the last one.
In C2 you write the formula:
=SUMPRODUCT((D2:AI2=1)*10+(D2:AI2=2)*7+(D2:AI2=3)*5+(D2:AI2=4)*2)
copy the formula down to the rest of the players.

in A2 you write the formula:
=RANK(C2,C$2:C$5)
copy the formula down to the rest of the players.

 

[ahsan88]

I got the rank part, However still confused on the sumproduct formula. here is what I have for a match sheet.

GameNO	1	2	3	4	5	6
Tariq	430	522	484	497	542	521
Major	550	454	600	491	482	494
Ahsan	498	482	560	467	521	518
Saad	393	417	419	424	486	544

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[iyyi]

If you have the Rank in column A, the Player in B, the Total Points in C and in columns D to AI you have the matches scores, e.g 1 for the winner, 2 for the second, 3 for the third and 4 for the last one.

The suggested formula was for a Worksheet with the structure above.