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

    From The Document Foundation Wiki
    Formula Description Returns
    =SUMIFS(B2:B6;B2:B6;">=20") Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Here the fifth row does not meet the criterion. 75
    =SUMIFS(C2:C6;B2:B6;">=20";C2:C6;">70") Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Here the second and the fifth rows do not meet at least one criterion. 275