▲ 1 r/libreoffice
Addition of table values (end of table): new row -> automatic adaption of sum formula (including new value)
Hello, I want to have a basic sum table with the last row as the sum of column values.
If I want to add a new value, I want to add a new row right above the sum row and I want the sum formula to adapt, e.g.:
Now if I add a new row at line 5 (sum then row 6), I want the sum formula to adapt to B2:B5. Then with another new value to B2:B6 and so on.
I tried to make it automatic with including the =ROW function, but I couldn't get it work ...
u/LimoCitron — 14 hours ago