Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Totals don't match (2003)

    This question was posed to me, and I am not sure why the totals don't match.

    Regarding the attached workbook: worksheet "Due 12 31 05," cell E10's formula uses the sum function. Worksheet "Due 12 31 05 (2)," cell E10's formula uses the =D10 formula.

    Using the Sum function for column E, cells 2 thru 30, the worksheets arrive at different totals. Why am I not arriving at the correct sum?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Totals don't match (2003)

    On your second sheet, the total formula in E30 does not refer to cell E10, hence the difference.
    HTH.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals don't match (2003)

    Oh good grief! Talk about blind. ... sigh.
    Thank you!

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals don't match (2003)

    Ahhh ha.. I went back to the user to show him our mutual stupidity. He sighed deeply and told me I don't understand his question. So, here it is:

    The method he used to total each of the worksheets is to select the entire range, including an extra blank row and then click the autosum button. Using this metehod, the worksheet with the cell reference of =D10 (in cell E10) does not pick up/include cell E10 in the formula range. If you select the range first and then click the auto sum button, it works fine. If you don't select a range at all and click in cell E29 and then click the autosum button, it does not include E10.

    My brilliant answer was, "don't do it that way." He didn't lilke that answer. He wants to know why the two methods don't provide the same results.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Totals don't match (2003)

    Excel tries to be smart. It sees that E10 contains a different type of formula than the other cells in column E, and therefore decides to omit it in the AutoSum formula.
    If you put =SUM(D10) in E10, the formula resembles that of the other cells, so AutoSum will include it.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals don't match (2003)

    Ok.Thanks.

Posting Permissions

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