Forum Discussion
Solved
SUM FUNCTION ADDS INCORRECTLY
I have used Excel for many years and this is the first time that the simple SUM function is adding $320.00 to my total for the column. The cell is, like always, =SUM(D18:D32) - but when I add the nu...
It is highly unlikely that Excel is adding cells incorrectly.
There's no doubt that it appears to be doing so, but let's face it: with the millions of people around the world that have formulas like =SUM(D18:D32) it just isn't going to happen that you, out of all of them, have the privilege of discovering a major bug in the SUM function.
So what we need to do is look for the source of that number, perhaps a cell that is hidden somewhere... have you hidden any rows in your spreadsheet? Are you using the filter capability?
Is it possible for you to post a copy of the spreadsheet itself on OneDrive or GoogleDrive, with a link pasted here that grants access?
Yikes, I had a row hidden. My mistake.