Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Total puzzle (XP)

    Please see attached. The number in the Total A.C.A. row are, obviously, not the result of a formula. If I make them the result of a formula, the answers are not the same. They need to be the same and they need to be the result of a formula in case the data in the related cells changes - duh - I got this from someone else who can't be reached to explain what the heck THEY did (besides eyeball the data and come up with an answer that's in the ballpark) - please help - and, as usual, I need the answer as fast as your brilliant brains can come up with one.

    Thanks again

    Aunt Linda

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

    Re: Total puzzle (XP)

    I don't see how the number 55.39 in cell E18 could be reconciled with the number 54.99 in cell E21 that results from the sum formula. The difference cannot be explained as a rounding error.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Total puzzle (XP)

    Thanks again, Hans. At least this time there really wasn't any answer! Go AuntLinda . . .

Posting Permissions

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