Goals statistics
Hello guys,
In the attached sheet I would like to calculate the percentage of the games in which one team scores and gets at least 3 or more goals (GG3+ shown in column "AC") per game from all the games that it played. Just as an info, the total number of games that each team is playing is 34 in one season so that would be the denominator by which we will divide the number of matches in which that team achieved GG3+ score.
It would be also good if you can provide a formula that shows top three teams based on this same criteria.
Thank you so much in advance on your expertise.
|