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:

[TABLE="width: 361"]
<colgroup><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD]Rank[/TD]
[TD]Player[/TD]
[TD]Played[/TD]
[TD]pts[/TD]
[TD]Total Points[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]Tariq[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2475[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]Major[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2577[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]Ahsan [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2528[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD]Saad[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2139[/TD]
[/TR]
</tbody>[/TABLE]

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.[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]GameNO[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64, align: right"]2[/TD]
[TD="width: 64, align: right"]3[/TD]
[TD="width: 64, align: right"]4[/TD]
[TD="width: 64, align: right"]5[/TD]
[TD="width: 64, align: right"]6[/TD]
[/TR]
[TR]
[TD]Tariq[/TD]
[TD="align: right"]430[/TD]
[TD="align: right"]522[/TD]
[TD="align: right"]484[/TD]
[TD="align: right"]497[/TD]
[TD="align: right"]542[/TD]
[TD="align: right"]521[/TD]
[/TR]
[TR]
[TD]Major[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]454[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]491[/TD]
[TD="align: right"]482[/TD]
[TD="align: right"]494[/TD]
[/TR]
[TR]
[TD]Ahsan[/TD]
[TD="align: right"]498[/TD]
[TD="align: right"]482[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]467[/TD]
[TD="align: right"]521[/TD]
[TD="align: right"]518[/TD]
[/TR]
[TR]
[TD]Saad[/TD]
[TD="align: right"]393[/TD]
[TD="align: right"]417[/TD]
[TD="align: right"]419[/TD]
[TD="align: right"]424[/TD]
[TD="align: right"]486[/TD]
[TD="align: right"]544[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.