Hello,
I'm creating a spreadsheet and I have a problem. Imagine that a tournament is taking place. To control this tournament I have several tabs, January, February, March, etc. Within each tab I have the names of the tournament participants, and how many points they made throughout that month. Not all players participate in the tournament every month.
In the January worksheet I have: Anderson - 10 André - 14 Bruno - 15
In the February worksheet I have: Anderson - 12 Bruno - 9 Carlos - 15
In the March worksheet I have: Anderson - 8 Carlos - 10 Daniel - 12
What I would like to do is, at the end of all tabs for each month, create a "Total" tab and gather the names of all participants. In this case: Anderson, André, Bruno, Carlos and Daniel
Adding all their respective points. In this case: Anderson - 30 Carlos - 25 Bruno - 24 André - 14 Daniel - 12
From what I read about, I need a matrix formula that does this, to scan the worksheet of the months, searching for the names and adding up their points. but I did not find anything approaching my needs and I could not do it on my own.
Could someone give me a light?