Translations:Documentation/Calc Functions/SUMIF/21/en

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