Ask Your Question

SUM of columns not correct [closed]

asked 2019-12-15 23:08:29 +0200

thisuldoit gravatar image

updated 2019-12-15 23:56:48 +0200

Opaque gravatar image

I have read various other posts and perhaps I am missing something, but I have been using this spreadsheet for quite some time and there has never been an error. Now the column total for Column I is not correct. It should be $2242.86, but is it coming up at $2242.73. Furthermore, when I add the 58.91 values together using the SUM function, it gives me 1531.53 instead of the correct value 1531.66. I believe I have searched for hidden values, etc, but I cannot resolve this. I have uploaded the file and appreciate your assistance! C:\fakepath\TEST FILE.ods

[Edit - Opaque] Inserted a space character after last exclamation mark to make the attached file a real link to a downloadable file.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-12-18 00:33:34.182381

1 Answer

Sort by » oldest newest most voted

answered 2019-12-15 23:31:58 +0200

Opaque gravatar image

updated 2019-12-16 16:54:23 +0200


just format your cells in column I to numbers having 4 decimal places and you'll recognize the mismatch of your actual results and your expected ones. You seem to expect formatting also performs some kind of rounding of values to 2 digits, which isn't true. The sum in your sample file is absolutely correct, but sum calculates the numbers stored (calculated) in the cells and not those shown to you by telling LibreOffice just to show 2-decimal places.

Thus changing the formula to: =ROUND((D3+E3)*0,7;2) will solve your problem (using SUM() is superfluous in this case) see also: C:\fakepath\RoundingError-Modified.ods

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Thank so much!! I have been an Excel user for a very long time, and I am trying to make the switch to Calc. I really appreciate your assistance!!!!

thisuldoit gravatar imagethisuldoit ( 2019-12-16 12:46:05 +0200 )edit

Question Tools

1 follower


Asked: 2019-12-15 23:08:29 +0200

Seen: 247 times

Last updated: Dec 16 '19