Created attachment 191233 [details] Calc file not displaying correct behavior. LibreOffice Version 7.5.8.2 Calc seems unable to process =SUM(B4:B15-B19), or =SUM(ABS(B4:B15)), or both together: =SUM(ABS(B4:B15-B19)). I've verified that these equations work in of Microsoft 365.
(In reply to falsettoggu from comment #0) > Created attachment 191233 [details] > Calc file not displaying correct behavior. > > LibreOffice Version 7.5.8.2 > > Calc seems unable to process > > =SUM(B4:B15-B19), or Perhaps you mean to sum the set of values from cell B4 up to cell B15 and then to subtract the value in cell B19. In that case use: =SUM(B4:B15)-B19 See also: https://help.libreoffice.org/7.6/en-US/text/scalc/01/04060199.html > > =SUM(ABS(B4:B15)), > > or both together: > > =SUM(ABS(B4:B15-B19)). > > I've verified that these equations work in of Microsoft 365. Excel 365 is probably using the "post-array formulas era" syntax. IIRC, the ABS() function expects a numeric value, or a cell with a numeric value. If you want a range as argument, you would need to use it as an array formula/function. Please go to https://ask.libreoffice.org for questions and leave this site for reporting bugs.