Sports Ladder Spreadsheet Help

[cgfw201]

Hi there,
Need some assistance with some formulas for a social squash league spreadsheet I'm creating to keep track on results and produce a live table.

Basic layout shown in pic, need some help with the following formulas please

- I2: COUNTIF for 'Toby' in Column C or Column F to show the total number of matches 'Toby' has played
- J2: Number of times 'Toby' has won, so IF he is player in Column C, then he needs to score more than player in Column F and vice versa, for 1 point
- K2: Opposite of J2
- L2: Total number of points 'Toby' has scored, adding Column D&E points together against his name
- M2: Opposite of L2
- N2: L2-M2
- O2: J2*3

With all this data, is it possible to have the table automatically sort itself in total points order each time it is updated?

Thanks in advance.

 

[alansidman]

crossposted: Sports Ladder Sheet Help

 

[SquashPlayer]

If any readers are interested in a more "off-the-shelf" approach to running squash leagues, ladders and tournaments (including excel spreadsheet versions of knock-out tournaments for 32, 16 and/or 8 player tournaments), they can try SquashLeagues.org. The knock-out tournament excel templates can be downloaded here

 

[SquashPlayer]

If any readers are interested in a more "off-the-shelf" approach to running squash leagues, ladders and tournaments (including excel spreadsheet versions of knock-out tournaments for 32, 16 and/or 8 player tournaments), they can try SquashLeagues.org. The knock-out tournament excel templates can be downloaded here

Sorry = forgot to mention the actual link in case my post doesn't link correctly:
The knock-out tournament excel templates can be found here: Managing Competitions