Translations:Documentation/Calc Functions/SUMIF/21/en
Formula | Description | Returns |
---|---|---|
=SUMIF(A1:A4;"<0") where A1,A2,A3,A4 are 3,-4,-5,-6 | sum up only negative numbers | -15 |
=SUMIF(A1:A3;">0";B1:B3) where A1,A2,A3 are 3,-4,5 and B1,B2,B3 are 2,3,4 | sums values from the range B1:B3 only if the corresponding values in the range A1:A3 are greater than 0 so here 3,5 are >0 hence 2+4 is returned | 6 |