Soccer Tournament Results - I need formulas to calculate statistics!

Greetings!

I need your help in creating formulas to calculate certain statistics in a school soccer/football tournament.
1. I need the total number of teams counted automatically
2. I need the goal difference (that of scored and conceded goals)
3. I need the points the teams earned (they get 3 for a win, 1 for a draw; 0 for a loss)
4. I need the number of how many matches they missed out of 11
5. I need the penalty points calculated (consisting of penalty points earned for yellow and red cards as well as missed matches)
6. I need the total number of points a team ended up with
7. I need the number of points they lost (compared to the maximum of points possible to earn)
8. I need the precentage of how many of the played matches did the given team win.

Finally, if possible, could you create a way put the teams (and their assigned statistics) in order based on their assigned statistics? Everything necessary is provided in a sample worksheet!

Thank you! Whoever this thread reaches, you are a life saver!

Here's a few of them, in the cells stated:

C7: =COUNTA(B10:B21)

I10: =G10-H10

J10: =3*D10+E10

K10: =$C$7-C10-1

N10: =K10*$C$5+L10*$C$4+M10*$C$3

They are not particularly difficult formulae, so see if you can work some of them out yourself, and come back if you have any problems.

Hope this helps.

Pete

Thanks for the rep - I presume you were able to work through the questions you had asked.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.


Pete