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

            Bug ID: 155758
           Summary: FUNCTION: suggestion for SUM.IF()
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: mco_documentfoundation.org_UnimailQeWEbOBj39z8Xb@dclic
                    .fr

Created attachment 187812
  --> https://bugs.documentfoundation.org/attachment.cgi?id=187812&action=edit
example for the suggestion for SUM.IF()

I suggest accepting functions in the "criteria" parameter.

Examples:
 > SUM.IF(E6:M6;AND(>0;<100);E7:M7)
 > SUM.IF(E6:M6;OR(AND(>0;<100);AND(>200;<300));E7:M7)

A detailed example is joined.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to