Forum Discussion
DJedit
Aug 12, 2020Copper Contributor
Excel sum
How can I get Excel to provide exact sums instead of averaging the data? When I enter values of 1.0, 1.5, 10.0, 8.0, and 0.75 into a column, I get a sum of 21.3 instead of 21.25. I need exact values ...
HansVogelaar
Aug 12, 2020MVP
Make sure that the column is wide enough to display 21.25
If the column is too narrow, Excel will drop decimal places:
Also, make sure that the number format is either set to General or to Number with 2 (or more) decimal places. If it is set to Number with 1 decimal place, the displayed number will be rounded (although the correct value is still stored in the cell)