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

From The Document Foundation Wiki
Jump to: navigation, search
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