Cumulitive scores across multiple sheets

[tahuhali]

Hello, I am hoping someone can tell me what functions I could use to achieve my goal.
I am planning on running an online Kahoot game with hundreds of players. Each time we play a game, I can download a report of all scores like such:

I am going to be doing several of these and I am wanting to get the cumulative Score for each player. How can make it so I have a column that totals the scores for all player across multiple sheets?

 

[cooper645]

will the players always be in the same order?

If so simply copy and paste scores in the next column and then use a column at the start to keep a check on total scores

SUM(C2:G2)

or as far across as the scores will go.

If they may be in a different order you can use an INDEX MATCH or a VLOOKUP to get the scores then copy and paste values and same detail with the cumulative score.

Rank scores and apply a filter
For example:

Book2
	A	B	C	D	E	F
1	Player Scores
2	Rank	Player	Cumulative Score	Game 1	Game 2	Game 3
3	1	Michelle	902	260	345	297
4	2	Wife	785	246	289	250
5	3	Me	771	335	141	295
6	4	Mike	703	335	127	241
7	5	Henry	658	141	177	340
8	6	Sarah	654	179	236	239
9	7	John	637	218	246	173
10	8	Albert	557	220	193	144
Sheet1

Cell Formulas
Range	Formula
A3:A10	A3	=RANK(C3,$C$3:$C$10,0)
C3:C10	C3	=SUM(D3:F3)