+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : calculations not matching

  1. #1
    Registered User
    Join Date
    04-12-2009
    Location
    Md.
    MS-Off Ver
    Excel 2007
    Posts
    10

    calculations not matching

    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
    Attached Files Attached Files
    Last edited by jaydr; 06-15-2009 at 10:49 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: calculations not matching

    Seems like you didn't include Minnesota stats in your sums in AH8:AJ8

    Formula in AH8 should be: =SUM(AH2:AH6) copied across
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    04-12-2009
    Location
    Md.
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: calculations not matching

    Thank you NBVC i knew a fresh set of eyes would find it. i have been looking for two weeks for the solution and it seems each time i missed that i forgot to sum on line.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1