Ask Your Question
3

Calc Problem (calculation returns incorrect result)

asked 2018-01-30 18:05:09 +0200

Hernan gravatar image

Hi, I'm about to give up with LibreOffice and find another alternative, simply because I have not been able to identify why SUMs is not giving the correct results.

I'm attaching a file, you can check the totals and would see the difference I'm talking about. (Sorry I won't be able to attach anything as I don't have 3 points)

Thank you for anyones support.

edit retag flag offensive close merge delete

Comments

Upvoted so you should be able to attach your file now.

peterwt gravatar imagepeterwt ( 2018-01-30 18:13:47 +0200 )edit

Surely you are trying to sum numbers that are as text in the cell, if it's the case, this value are summed only when they are reference directily but not through a range, SUM(A2) works but SUM(A1:A3) not.

m.a.riosv gravatar imagem.a.riosv ( 2018-01-30 23:30:22 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-02-01 01:16:20 +0200

Double click the cell the formula is in. It should then high lite all the cells it is adding up, to help see what it is doing. Or create a new Sum, with the Function Wizard, just left of the formula bar, it helps in building formulas in empty cells and will also show the structure of a cell with a formula, like your Sum formula.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-30 18:05:09 +0200

Seen: 65 times

Last updated: Feb 01 '18