[Libreoffice-bugs] [Bug 123075] In CALC i cannot easily get a sum of the numbers in a numeric column when i am in a row filtered view

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123075

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #2 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190131/520e3168/attachment.html>