Forum Discussion
Jean_Russell
Aug 12, 2023Copper Contributor
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...
- Aug 12, 2023
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?
mathetes
Aug 12, 2023Silver Contributor
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?