At MrExcel you said:
Quote:
|
In one season, which consists of 34 games, Dortmund played in 21 games where there were "3+" which is a 61.7%.
|
Here's a screenshot of all Dortmund's games.
It looks like they played 31 games, not 34 as there's no score and no date for 3 of them.
Quote:
|
…21 games where there were 3+ !!
|
I count only 15 (marked in column I with an x). This about 48% (15/31).
(And only 2 games where both teams had 3+ goals)
Can you confirm that I should only be looking at columns F & G because they are the full time scores?
2024-10-23_172940.jpg
Please add any other links to wherever else you've posted this question to.
Formula to count % of goals in a total number of games | MrExcel Message Board
2024-10-24_173155.jpg