https://bugs.documentfoundation.org/show_bug.cgi?id=123075
Oliver Brinzing <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #2 from Oliver Brinzing <[email protected]> ---
(In reply to William Signer from comment #0)
> when I do a sum in a column cell below the filtered column I get the sum of
> the filtered rows in the column plus the sum of the hidden cells in that
> column
to get the sum of the filterd rows you have to use "=subtotal(9;cellrange)"
instead of "=sum(cellrange)", e.g. =SUBTOTAL(9;C5:C8)
https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
