AutoSum will not expand when line inserted

Using version 7.3.7.2
I have a column containing numbers.
At the bottom of the column I use the Sum Icon on the tool bar to total for me.
If I insert a row directly above the total, and enter a value,
the amount it will not be included the sum, but if I select the total,and click the icon the correct total will be displayed.
If I insert a row anywhere else in the column the total will include this amount without manual intervention. Perhaps I miss understand the working of auto sum here but have tested in a compatible program an it works as I expect.

You must insert a row INSIDE the SUM range - if you want expand the range of the summarization automatically.

1 Like

BTW, maybe what you need it’s enable the option:
Menu/Tools/Options/LibreOffice Calc/General - Expand references when new columns/rows are inserted.

1 Like

Thank you Miguel