Formula to identify which teams and their percentage with the highest % of goals scored

[VKiprijan]

Hi to all Excel experts,

I want to make a statistic table that will show which soccer teams have the highest prevalence in goals scored when they played against other teams over the whole season. The source of those goals is in the columns P thru Z and the table that will show these soccer teams and its percentage is in AO28:AR39.
Just to give you an example, let's compare which soccer teams had the most frequent number of goals 0-1. If we do the manual count of 0-1 occurrence in column P we can determine that there were four teams with the highest prevalence of 0-1 goals in 8 out of 31 games played (25.81%). That same calculation can be done for other criteria such as 2+, 3+ or more goals per game.
What I need is actually a formula that can count this percentage for me. I am using Excel 2016 so unfortunately, I can't use XLOOKUP function. So, I guess the formula should contain formulas such as INDEX, MATCH, VLOOKUP or even some statistical formula.

I have attached the file for you to review it.

Any idea how the formula should look like?


Thanks everyone in advance.

 

[vletm]

VKiprijan​

As You've read while You selected Forum:
Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Do You have a solution?
or
do this belong to other Forum?

>>> Moved to Other Forum <<<

 

[AliGW]

Cross-posted: https://forum.ozgrid.com/forum/inde...their-percentage-with-the-highest-of-goals-s/

 

[vletm]

VKiprijan

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

As You have read from Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[Fluff13]

Also on XlGuru, MrExcel, ExcelForum, MSOfficeForums and probably others.

 

[VKiprijan]

Hi everyone,

I have also cross-posted this topic on the following forums:

https://www.msofficeforums.com/excel/52938-formula-count-goals-total-number-games-2.html

https://www.mrexcel.com/board/threa...l-number-of-games.1265877/page-2#post-6225534

https://forums.excelguru.ca/threads...the-highest-of-goals-scored.11965/#post-49520

https://forum.ozgrid.com/forum/inde...their-percentage-with-the-highest-of-goals-s/

https://chandoo.org/forum/threads/f...ntage-with-the-highest-of-goals-scored.57887/

Formula to identify which teams and their percentage with the highest % of goals scored

Hi to all Excel experts, I want to make a statistic table that will show which soccer teams have the highest prevalence in goals scored when they played against other teams over the whole season. The source of those goals is in the columns P thru Z and the table that will show these soccer...

www.excelforum.com

Thanks.