trouble using sum command

asked 2017-09-17 18:24:00 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a mileage spreadsheet with columns for start of journey and finish mileage, the next column is the difference between the first two figures, when I use the sum command on the difference column the answer is different to the start and finish difference, using one or two examples gives the correct answers, over many entries(200+) and the answers differ by 2000 miles, can you be of assistance?

Thankyou moneypenny

edit retag flag offensive close merge delete


An example file with a problem please. See here for an example, when a similar problem was unsuccessfully discussed until a sample came, and then it only took a couple of minutes to solve.

Mike Kaganski gravatar imageMike Kaganski ( 2017-09-17 21:15:46 +0100 )edit

Pls inform also about your LlibreOffice version, If I remember right, about a year ago there were issues with OpenCL enable (Menu/Tools/Options/LibreOffice) with ranges large than 100 cells.

m.a.riosv gravatar imagem.a.riosv ( 2017-09-18 02:21:32 +0100 )edit