Forum Discussion
My Percentage of total sales is not 100 - Why?
Nathalie135 Not sure about your arithmetic. When I add-up the sales amounts, I come to just over 6.1 million. I.e. not 3.2 million. That's a factor 1.9235 higher. That's why you get the wrong overall percentage. And, of course, you may add up individual percentages, provided you calculated them on the correct basis.
- Thank you, I thought it looked wrong, I'm not sure what the cell formatting was doing but it was definitely doing something weird. These numbers are what I thought they should have been. When I cleared the formatting of the cells and summed it again I finally got the correct numbers (your numbers). Thanks again
Nathalie135.... FYI, "cell formatting" cannot explain the difference between 3.2 million versus 6.1 million.
A more likely explanation is: the summation cell was not recalculated. And beware: that might still be an ongoing issue, remedied on a one-time basis because the changes that you made forced a recalculation.
In the future, attach a example Excel file that demonstrates the problem so that we can see your formulas, the original data, and the settings of workbook-specific options.
- Will do, thank you, I will keep an eye out for that and send a bit more detail next time. Thanks again 🙂
