https://bugs.documentfoundation.org/show_bug.cgi?id=158789
Bug ID: 158789
Summary: Allow SUMIF and SUBTOTAL to apply to arrays
Product: LibreOffice
Version: 7.6.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The following resolves to 0 rather, than resolving to 60, which it would
resolve to if a cell reference range to cells of the same values was given.
=SUMIF({-10,10,20,30},">0")
Could support for passing arrays to SUMIF and SUBTOTAL be added?
--
You are receiving this mail because:
You are the assignee for the bug.