Douglas Edward
New Member
- Joined
- Jul 24, 2018
- Messages
- 22
- Office Version
- 2019
- Platform
- Windows
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!
<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>
<tbody>
</tbody>
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
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>