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.

Reply via email to