Baseball Statistics

baseball_stats

New Member
Joined
Apr 26, 2017
Messages
2
I'm trying to, what I think is, 3-D Cell References across worksheets to calculate a baseball league's statistics.

My document can be downloaded here: http://twitterbaseballny.com/wp-content/uploads/2017/04/2016-Twitter-Baseball-League-Wide-Stats.xlsx

I've set up my excel file with the first sheet for the cumulative numbers from the proceeding worksheets of individual boxscores of each game. So, for example I would like to add-up all the ABs from all the boxscores for each individual player. Each player will not appear in each game and when they do appear in a game, their spot in the worksheet will vary. I tried on player Garcia, Mark who played in only G1 and G4.

I'm thinking there must be away to tell excel to only add a specific column across worksheets when the name in a row matches the name in the row on the first worksheet.

I followed this video but to no success; https://www.youtube.com/watch?v=tmh5vI5dK6o

Any help is very much appreciated.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top