Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-23-2024, 04:58 AM
VKiprijan VKiprijan is offline Formula to count % of goals in a total number of games Windows 10 Formula to count % of goals in a total number of games Office 2016
Novice
Formula to count % of goals in a total number of games
 
Join Date: May 2023
Posts: 15
VKiprijan is on a distinguished road
Default

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.
Reply With Quote
 

Thread Tools
Display Modes


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
Formula to count % of goals in a total number of games 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
Formula to count % of goals in a total number of games 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 to count % of goals in a total number of games Formula for calculating total when number and letter in one cell Oleg Excel 5 02-22-2017 03:05 AM
Formula to count % of goals in a total number of games Word: count total page of each section salmonrose Word 1 10-15-2011 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft