10-08-2019 10:30 PM
this is the sum Statement
The numbers just don't add up
The top pic is the formula.
The bottom pic is p18 to x18 and the numbers don't add up
Suggestions on how to fix and what is causing the problem.
Scary if you can't trust Excel to add correctly.
10-09-2019 12:01 AM
10-09-2019 12:23 AM
The chance that Excel has performed the summation incorrectly is so small that it is hardly worth considering. The chance that it has performed an incorrect summation is far greater since it is the user that specifies the calculation and error is a fundamental part of human behaviour.
The first thing I would observe is that Excel has flagged every 'incorrect' result with a green marker in the cell corner. I cannot tell what is wrong from a picture but the error flag should provide a clue.
10-10-2019 06:32 AM
10-10-2019 11:06 PM