Help Please. How to keep a running total from multible events.

[Douglas Edward]

I want to keep a running total of Points, Events, and Cashes from 40 events.
The players will vary from each event.
And the list of players in the "Total Table" will grow.
Also the Player "Rank" will be resorted after every event.

I'm still a beginner, and learning as I go.

What am I missing in my formula? It won't add if a player is not in all Event Tables.

And what is a simpler way since I will be adding 40 events?

Thanks for your help!

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Totals						Event 1					Event 2
2	Player	Rank	Points	Events	Cashes		Player	Points	Events	Cashes		Player	Points	Events	Cashes
3	D	1	160	2	2		A	0	1			A	100	1	1
4	C	1	150	2	1		B	50	1			B	0	1
5	A	2	100	2	1		C	100	1	1		C	50	1
6	B	3	50	2	0		D	80	1	1		D	80	1	1
7	E	4	0	2	0		E	0	1			E	0	1
8	F		#N/A	#N/A	#N/A		F	60	1			H	0	1
9	G		#N/A	#N/A	#N/A		G	0	1			I	60	1
10	H		#N/A	#N/A	#N/A
11	I		#N/A	#N/A	#N/A
12

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C3 =VLOOKUP([@[Player ]],Event1[[Player ]:[Points]],2,FALSE)+VLOOKUP([@[Player ]],Event2[[Player ]:[Points]],2,FALSE) D3 =VLOOKUP([@[Player ]],Event1[[Player ]:[Events]],3,FALSE)+VLOOKUP([@[Player ]],Event2[[Player ]:[Events]],3,FALSE) E3 =VLOOKUP([@[Player ]],Event1[[Player ]:[Cashes]],4,FALSE)+VLOOKUP([@[Player ]],Event2[[Player ]:[Cashes]],4,FALSE) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Douglas Edward]

oops, I made a mistake. B3-B7 should be 1,2,3,4,5.

 

[Peter_SSs]

Just confirming ..

- Totals and each 'Event' is a separate Excel Table, but
- all in the one sheet &
- all with headings in row 2 &
- spaced every 5 columns (after the Totals table which is an extra column wide)?

 

[Douglas Edward]

Good question.
What is the best way to set it up?
Should I use tables?
Should I keep it all on one sheet, or use separate sheets for each event?
Should I keep the same number of columns in each table?

I'm open to any suggestions.

 

[Peter_SSs]

What is the best way to set it up?
Should I use tables?
Should I keep it all on one sheet, or use separate sheets for each event?
Should I keep the same number of columns in each table?

Tables or not doesn't really matter for this suggestion, but I have set my sample up with tables.
Keep all the event tables the same size(ie same number of columns) with columns in the same order in each table & all side-by-side across a single sheet as shown below.
Then use formulas like these in the Totals table.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Totals						Event 1					Event 2					Event 3
2	Player	Rank	Points	Events	Cashes		Player	Points	Events	Cashes		Player	Points	Events	Cashes		Player
3	D	1	160	2	2		A	0	1			A	100	1	1
4	C	2	150	2	1		B	50	1			B	0	1
5	A	3	100	2	1		C	100	1	1		C	50	1
6	B	4	50	2	0		D	80	1	1		D	80	1	1
7	E	5	0	2	0		E	0	1			E	0	1
8	F		60	1	0		F	60	1			H	0	1
9	G		0	1	0		G	0	1			I	60	1
10	H		0	1	0
11	I		60	1	0
12
Totals

 

[Douglas Edward]

Thank you Peter! This is exactly what I was looking for.

 

[Peter_SSs]

Thank you Peter! This is exactly what I was looking for.

You're welcome. Thanks for letting us know.