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

p45cal · #22 10-31-2024, 03:14 AM

Quote:

Originally Posted by VKiprijan

But will it show the results for other teams in different tabs or the function has to be adjusted for each tab?

As long as the data in each tab is laid out in a similar way, that is with 7 columns next to each other:

2024-10-31_100509.jpg

then as long as you have a column somewhere with the goal ranges, like:

2024-10-31_100728.jpg and you adjust the ranges referred to in the function to those cells, there should be no problem.

Note that the function doesn't use the first half results at all (columns 3 and 4 of the referred-to source data), so they could be blank.

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