Hi,

Yes, we can take Eintracht Frankfurt, for example, which plays home and away games and sometimes in those games there are at least 3 or more goals (3+) scored by both teams.
If there are 10 games played so far, I would like to calculate how many times there were "3+" goals in those games which Eintracht Frankfurt played. So, if for example Eintracht Frankurt played 5 games with 3+ goals out of 10 games that percentage will obviously be 50%.

So, how do we create a formula that will show the list of the teams (cells AP29-AP39) that score the most 3+ goals (percentage in the cells AR29-AR39)?


Thanks.