Moving Formulas when Sorting a table
 

Hi All & Happy Christmas & New Year,

How can I sort a league table and have the formulas move to the new cells?

I'm working on a World Cup Spreadsheet.

I've got each table as below

a b c d e f g h i

P W D L F A Pts GD
Team A c3 c4
Team B
Team C
Team D

The fixtures are below each table and the results of these are what develops
the table.

E.G.
For Team A won in C3 I've got =SUM(A11+A15+K21)
Team A Draw in C4 I've got =SUM(B11+B15+L21)

The above cells are static (don't move) and will either contain 1 or 0.

When I sort the league table, the teams move but this makes the formulas get
messed up - if Team D moves to 1st place in the table (move up 3 places), the
formulas refer to 3 cells above the originals so that's not right - I need
the formulas to always refer to the original cells.

Thanks for any answers & help in advance
John