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

[euan26]

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.

[librebel]

Hello @euan26,

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

[mariosv]

And please, LibreOffice version and Operating System.

[euan26]

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

[librebel]

please try =SUM(E:E) instead