Excel Formula doesn't calculate correctly

Question

Hope someone can help point me in the right direction.

This formula is not calculating correctly in my Excel 2010  workbook.

  =SUM(B10:E10)-G10 

Evaluate formula shows:

           1st                    =SUM(B10:E10)-G10    

           2nd                              =2,340.28-G10

           3rd                               =2,340.28-0

           4th                               =2,331.31

Total should be   2,340.28

  The workbook is set to automatically calculate  and is the only workbook open.  Hitting F9 does nothing.  Closing and re-opening does nothing.  If I re-enter or change one of the amounts from the input cells the formula will automatically recalculate correctly.  If after making a change I hit undo the formula stays correct and does not go back to the incorrect calculation.

Can any one tell me what may be causing this problem?   My concern is that I have hundreds of workbooks with formulas that I assume are calculating correctly and it was only dumb luck that I happened to notice this slight discrepancy shown above.

Thank you.

Answer 1

TBH, it's pretty hard to diagnose an issue like this without seeing the workbook or at least a redacted copy of the worksheet. Could you post a redacted sample of the worksheet to a public access file area like OneDrive, DropBox or Google Drive and post a link to the publicly shared file back here. A firsthand look at the data, formulas and formula evaluation would help immensely. A huge mathematical error must have some underlying reason but I cannot determine anything specific that you have not already covered in your description.

Answer 2

Hello,

what are the values in the cells? Can you share a workbook with the faulty behaviour in your Onedrive public folder for inspection?

Answer 3

Here's the link to the file... thanks for looking at this.

https://drive.google.com/file/d/0B8LJFJuWB-\_bZWFHYVZwaWNjZkU/edit?usp=sharing

Answer 4

The link does not work. I don't know how Google drive works. Save your file into your OneDrive public folder, share it, and post the link.

Answer 5

I caught a copy from the Google drive. Here is a direct link to my public DropBox.

Copy of DETAIL BALANCE 2014 - Copy.xlsx

addendum: I can get the correct SUMs into the status bar by selecting the cells and can correct the =SUM(...) formula results by tapping F2 then Enter or changing of the referenced values but as yet I am dumbfounded as to why the calculation isn't showing the correct results right away.