Wierd issue with excel

dougwhiterules2000

New member
Joined
Aug 23, 2013
Messages
1
Reaction score
0
Points
0
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?
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
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).
 

Attachments

  • TextNumber.xlsx
    10.9 KB · Views: 7
Top