Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2023, 01:28 PM
VKiprijan VKiprijan is offline Goals statistics Windows 10 Goals statistics Office 2016
Novice
Goals statistics
 
Join Date: May 2023
Posts: 4
VKiprijan is on a distinguished road
Default Goals statistics

Hello guys,



In the attached sheet I would like to calculate the percentage of the games in which one team scores and gets at least 3 or more goals (GG3+ shown in column "AC") per game from all the games that it played. Just as an info, the total number of games that each team is playing is 34 in one season so that would be the denominator by which we will divide the number of matches in which that team achieved GG3+ score.

It would be also good if you can provide a formula that shows top three teams based on this same criteria.

Thank you so much in advance on your expertise.
Attached Files
File Type: xlsx Soccer League v2.xlsx (137.1 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goals statistics Readability Statistics Not Presented Andrew H Word 3 10-24-2018 01:22 PM
Statistics for large documentation Zgrzytek Word 0 11-16-2017 03:23 AM
Chart with Actuals and Goals for Multiple INTL Regions Italiano329 Excel 4 01-22-2016 09:48 AM
Word Doc Statistics page graeme Word 0 09-19-2011 09:10 AM
Outlook Calendar Statistics MihaiBB Outlook 0 12-11-2008 03:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:46 AM.


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