I have a column of numbers B2 through B13 with currency values in them. I use =sum(b2:b13) in column b14. In B15 I have a subtraction. =A1-B14 The problem is that when I change an amount in B2 to B13 the subtraction box does not auto update. I have to go B15, go the input box and then press enter key for the amount to update to the correct amount. I’m using Libreoffice calc 7.02.2 Any help will be appreciated.
