I have a spreadsheet where the sum function returns the wrong answer. If I highlight the cell range the correct answer is displayed in the status bar. This only happens in columns W and X. Is there some new bug in Excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sum error
- Thread starter nekthen
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,292
- Office Version
- 365
- Platform
- Windows
It is hard to say, as you have not shown us your sum formula, nor the data ranges it is looking at.
And we have no idea what columns and rows we are looking at based on your screen print.
But be careful NOT to include dates in your sum range, as dates are actually stored in Excel as numbers (specifically, the number of days since 1/0/1900).
So including cells with dates in them in your sum range would mess up your totals.
And we have no idea what columns and rows we are looking at based on your screen print.
But be careful NOT to include dates in your sum range, as dates are actually stored in Excel as numbers (specifically, the number of days since 1/0/1900).
So including cells with dates in them in your sum range would mess up your totals.
Upvote
0
I realise that the screen shot is not ideal, but I cannot install any software like xlsbb.
I have had other people look at this and I am not a novice.
The value dispaying 24457 is a sum on the same range as the sum value at the bottom 22680
I have independently confirmed that this is the correct value.
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,292
- Office Version
- 365
- Platform
- Windows
I don't think there is a bug - I think you may be including something that you are not aware of, or your SUM formula is including more than you think.
(If there was a bug, I think it would be a pretty big thing, and widely known - I have used 365 for years and have never had an issue with the SUM function).
Can you at least show us the exact formula you are using, and screen prints of the of the sheet where the data and end the end, where the data ends?
Be sure we can see the row and column headers in those screen prints.
Your other option would be to upload a copy of the file to a file sharing site (like StopBox, OneDrive, etc) and provide a link to it so we can download a copy, and view your issue firsthand.
Just be sure to remove any sensitive data first if you go that route.
(If there was a bug, I think it would be a pretty big thing, and widely known - I have used 365 for years and have never had an issue with the SUM function).
Can you at least show us the exact formula you are using, and screen prints of the of the sheet where the data and end the end, where the data ends?
Be sure we can see the row and column headers in those screen prints.
Your other option would be to upload a copy of the file to a file sharing site (like StopBox, OneDrive, etc) and provide a link to it so we can download a copy, and view your issue firsthand.
Just be sure to remove any sensitive data first if you go that route.
Upvote
0
Similar threads
- Solved
