Created attachment 143031 [details] Example of wrong and expected sum Hello, Thanks for your work but I've just discovered that function SUM doesn't give the expected result if there's a $ in the data range. I send you an example. Many thanks
You use wrong syntax to define a range to sum. You need to use =SUM($A$3:A3) in the B3, note the colon (:) between the cell addresses - this defines the range (see https://helponline.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html ). You used function parameter separator instead (; or , - depends on your settings), which tells SUM to treat the two parameters as individual operands, which must be summed up. Closing INVALID.
See the SUM function reference:https://help.libreoffice.org/6.0/en-US/text/scalc/01/04060106.html#bm_id3163608 > =SUM(A1;A3;B5) calculates the sum of the three cells. > =SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range.