the sum of a column of figures does not change if I change a figure in the column ?

asked 2017-09-09 14:02:26 +0200

euan26 gravatar image

John 850

100

100 100

1050 The sum of this column did not change when I added an additional amount of 100 only happening on one sheet that I can see but not confident.

edit retag flag offensive close merge delete

Comments

Hello @euan26,

please post here the formula of the cell which should sum up your column.

librebel gravatar imagelibrebel ( 2017-09-09 20:56:03 +0200 )edit

And please, LibreOffice version and Operating System.

m.a.riosv gravatar imagem.a.riosv ( 2017-09-11 00:25:59 +0200 )edit

Hi librebel, formula reads =SUM(E3:E11) Libre version 5.3 Thanks

euan26 gravatar imageeuan26 ( 2017-09-11 13:58:28 +0200 )edit

please try =SUM(E:E) instead

librebel gravatar imagelibrebel ( 2017-09-11 14:10:21 +0200 )edit