I am keeping track of stats for my favorite baseball team. i have a sheet that keeps the total # of pitches both for individual pitchers and by the teams they face and the divisions. my problem is the sum of the pitchers should equal what i get when i add the divisions up but there is a 212 total pitch difference in the totals i add up for the individual pitchers and by division. There is also a 134 difference in strikes and 78 difference in the number of balls thrown.
i get the totals for the individual pitchers from the third section in the individual teams labeled with vs team h&a the each division totals taken from the sum of each pitchers pitches for each team. i have gone over everything several times to find what is wrong but i can't find it. the totals should match up. i hope a fresh set of eyes can find the problem.
i am attaching the sheet in question the problems cells are highlighted.
Thank you for your help
Bookmarks