gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 346
- Office Version
- 365
- Platform
- Windows
- Mobile
I have a large sheet with soccer players & the number of goals they have scored each season (each column is 1999-2000, 2001-2002, etc. up to 2019-2020). The players names are often duplicated down about 3500 rows of data. How can I get a single row count of all their goals?
For example:
<tbody>
</tbody>
For example:
Row/Column | A | B | C | D | E |
1 | Player | 99-00 | 00-01 | 01-02 | ... |
2 | Raul | 0 | 7 | 0 | 0 |
3 | David Beckham | ||||
1822 | Raul | 0 | 0 | 3 | 0 |
2455 | Raul | 0 | 0 | 0 | 12 |
<tbody>
</tbody>