How do I create team scores from data in a table of players scores.

[fredqwerty]

Ok I want to make two tables in an Excel sheet. One for players and one for teams.

From columns A to C I will have a table for players cumulative scores for each week.

From columns E to G I will have a table for teams scores worked out from the players in the first table.

There are five teams and five players per team

The Players Table would look like:-

A B C
1 Pos Player Score
2 1 Smith 81
3 2 Jones 77

The teams cumulative scores in the second table need to be of the five players in the first table. I could use something like =SUM(C1+C4+C6+C12+C20) etc but as soon as I sort the Players Table by score the team scores change to the wrong players.

[Moo the Dog]

Add another column (using M for my example) to hold a Team # for each player (1,2,3,4 or 5), then you can use this formula to sum a particular team's scores:

For Team 1: =SUMIF(M1:M25,1,C1:C25)
For Team 2: =SUMIF(M1:M25,2,C1:C25)
etc.

Hope this helps.

- Moo