Forum Discussion
SUM FUNCTION ADDS INCORRECTLY
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?
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?