Need help creating a sum value using multiple values, using a column, not a pivot table

I have a range of data where I need to find the sum of two specific values for one identifier, in a range of data. Sort of.

Here's an example:

Several baseball players stats come through with a list of types of hits, other at-bats (walks, Hit By Pitch, etc.) and the data comes through with the totals for hits and other at-bats, but not totals of all of that per player.

Example: Player 25 shows the details of their "At Bats", which would be there for all the players. Each player has the "TotalHits" and "TotalOther" amounts. I repeated the values for each player just to make it quick.


Player AtBats Amount

25 Singles 18
25 Doubles 9
25 HomeRuns 3
25 Walks 12
25 HBP 8
25 TotalHits 30
25 TotalOther 20
26 Singles 18
26 Doubles 9
26 HomeRuns 3
26 Walks 12
26 HBP 8
26 TotalHits 30
26 TotalOther 20
27 Singles 18
27 Doubles 9
27 HomeRuns 3
27 Walks 12
27 HBP 8
27 TotalHits 30
27 TotalOther 20
11 Singles 18
11 Doubles 9
11 HomeRuns 3
11 Walks 12
11 HBP 8
11 TotalHits 30
11 TotalOther 20
13 Singles 18
13 Doubles 9
13 HomeRuns 3
13 Walks 12
13 HBP 8
13 TotalHits 30
13 TotalOther 20
18 Singles 18
18 Doubles 9
18 HomeRuns 3
18 Walks 12
18 HBP 8
18 TotalHits 30
18 TotalOther 20

I need to find a way (not in a pivot table) to return a value of the total At-Bats for each player. The statistics come through monthly, and the range of players changes each time, with new players added and some players moving on to other things, so there would be a master list of the player's numbers in another tab of the worksheet where potentially the value may go.
The data in my real-world condition has more variables, and so the "Total" identifiers ad their values in the cells to the right of them are my concerns, as well as the Player number as a lookup reference.

I know that this can be done more easily in a pivot table, but I need the total value in a static column that won't move right or left depending on the number of types of variables.

Thanks for any help you folks might be!

Dewd