Results 1 to 2 of 2

Thread: Wierd issue with excel

  1. #1

    Wierd issue with excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    So I am summing data. I have a row of numbers, and I take a number out of one cell and put it into another cell - the same number - the totals change. Anything weird you know of with the sum formula in Excel?

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    I think we would need to see the spreadsheet to explain it, but there is one thing that might be causing it. Excel could be treating one or more cells in the row as text (even though they are numbers).
    In my example, I have values formatted as dollar currency, but Ive entered the value in D4 including the dollar sign as well, as you can see if you view this cell in the formular bar. This is treated as text, and omitted from the total in H4.
    However, if you clear the contents in D4 and enter 35 in cell G4 the total increases to the correct figure of 277. I think that this is the behaviour your describing.
    If you can't post your spreadsheet, try the following:

    1. Try to get a verification of your total, using either a calculator, or by re-typing the numbers into another row or column (just the numbers, nothing else). If you get a different total, look for a value equal to the difference in the original row.
    2. Inspect each cell value in the formula bar, looking for anything different compared with other cells (particularly the one whose value is the difference, if you can find it).
    Attached Files Attached Files

Posting Permissions

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