Translations:Documentation/Calc Functions/SUMIFS/31/en

    From The Document Foundation Wiki
    Formula Description Returns
    =SUMIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6)) where E2 = pen If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. Here the link to the cell is substituted with its content. 65