I keep a payment log in libre office calc. At the end of the column, I created a very simple SUM formula (Example: =SUM (A1:a273)
Every time I add a payment to a column, I save the work. Recently, I noticed the numbers were NOT correct, so I checked the “formula” which was correct. Still not right, so I RE-TYPED the formula (Same example: =SUM (A1:a273) and the resulting numbers changed. Now, I find that I need to re-enter the formula EVERYTIME I add another pament.
I don’t get it. Why is this happening? It’s really simple calculations and it’s not producing correct data…please advise
eeigor - That was it! AutoCalculate :0)
