Soccer League Workbook

[soccerlisa9]

Good Evening,

I am in charge of creating the workbook to use for the soccer league I play in to keep track of the top scorers for both male and female players, and also for the red cards and yellow cards.

I have sheet with tables for each team with each player, their gender and how many goals they scored from week 1, week 2, etc.
I want that to be able to get the total of each player in the league and rank them on a different sheet.
It’s hard to explain, but I need some help with the formulas to do this so that way when we get the results we can just add them to each week and it’s generated on the separate sheet.

Thank you!

 

[hagia_sofia]

Hello, it would be helpful if you could upload a sample of the data and demonstrate/describe how the output should look like...