Forum Discussion

DJedit's avatar
DJedit
Copper Contributor
Aug 12, 2020

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 ...
excel
mtarler's avatar
mtarler
Silver Contributor
Aug 12, 2020
that is probably just a display issue. If you change the cell format to display additional decimal places you should be good. Under Home -> Number Group click the button with and arrow to the left to add additional decimal places.
  • DJedit's avatar
    DJedit
    Copper Contributor
    Aug 12, 2020

    hmm. tried that. Expanded number of decimal places to three, highlighted the numbers I want summed, chose the Sum function, and got the rounded number.

    mtarler 

Resources