What code or formula is needed for the ‘Entries’ (Columns B, G, L), ‘Points’ (Columns C,H,M)
for each individual name to be totalled. The Entry’s name to appear in Column O and Total race points to appear in Column T
The lists can be quite long
Below is example only
Thanks
Ted
for each individual name to be totalled. The Entry’s name to appear in Column O and Total race points to appear in Column T
The lists can be quite long
Below is example only
Thanks
Ted
JR Race Daze2.xls | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
1 | LURE | HURDLES | COURSING | ||||||||||||||||||
2 | Entry | Points | Entry | Points | Entry | Points | Entry | Attendance | Starts | Totalracepoints | |||||||||||
3 | Twister | 6 | Twister | 6 | Smithy | 6 | Twister | 12 | |||||||||||||
4 | Ajay | 5 | Ajay | 5 | Alex | 5 | Ajay | 10 | |||||||||||||
5 | Cartman | 5 | Cartman | 4 | Benson | 5 | Cartman | 11 | |||||||||||||
6 | Max | 4 | April | 1 | Doc | 4 | O'Toole | 13 | |||||||||||||
7 | O'Toole | 4 | Cheese | 4 | O'Toole | 4 | Ace | 6 | |||||||||||||
8 | Rose | 4 | Mouse | 4 | Rose | 4 | etc | etc | |||||||||||||
9 | Chase | 3 | Ace | 3 | Ace | 3 | |||||||||||||||
10 | Molly | 3 | O'Toole | 5 | Mouse | 3 | |||||||||||||||
11 | Mouse | 3 | Rusty | 3 | Tyson | 3 | |||||||||||||||
12 | Tyson | 3 | Timu | 3 | Vanilla | 3 | |||||||||||||||
13 | Buddy | 2 | Chase | 3 | Benson | 2 | |||||||||||||||
14 | Entry | 2 | Harry | 2 | Cartman | 2 | |||||||||||||||
Point Score |