Hi....

I am running a fantasy football league and need help with my spreddy.... as a check that current scores are correct

In this spreadsheet... I have a weekly tab... which is where i need the help...it is basically a copy and paste of the weeks score from the fantasy football website...
First week was 17th Aug, second week 24th Aug. Columns I have are: position
manager name
team name
week points
total points...
top scorer for the week is always top in website... so I need sum that works for unsorted data tables really... as these are not sorted by name... i need to create a formula that takes the current weeks score and subtract from the previous week ... i dont want to use the basic sum function as its too long winded ... id like to sum it by looking at the manager name/team name... how do you do this for two sets of tables....example of sheet

August
Weekend 17-Aug
Pos. Manager Team Name Week Total
1 Manager 1 Team 1 101 101 (need formula
2 Manager 2 Team 2 87 87 for total column)
3 Manager 3 Team 3 87 87
4 Manager 4 Team 4 85 85
5 Manager 5 Team 5 83 83
6 Manager 6 Team 6 74 74

August
Weekend 24-Aug
Pos. Manager Team Name Week Total
1 Manager 4 Team 4 100 185
2 Manager 1 Team 1 90 191
3 Manager 2 Team 2 20 107
4 Manager 3 Team 3 80 167
5 Manager 6 Team 6 123 197
6 Manager 5 Team 5 80 163