Translations:Documentation/Calc Functions/SUMIFS/27/en
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 |