Formula to count % of goals in a total number of games

p45cal · #5 10-23-2024, 09:36 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count formula to count based on multiple criteria and return unique rows	Sphinxakop	Excel	0	02-01-2023 12:18 PM
How can I count per year and per week the total number of times a code occurs	Stefan_Deckers	Excel	3	09-19-2020 02:36 PM
Why does the total row of my pivot table not tie to the real count using distinct count	wheddingsjr	Excel	4	09-01-2020 09:52 PM
Formula for calculating total when number and letter in one cell	Oleg	Excel	5	02-22-2017 03:05 AM
Word: count total page of each section	salmonrose	Word	1	10-15-2011 05:10 AM