SUMIF function

SUMIF adds the cells specified by the given criteria. This function is used to browse a range when you search for a certain value.


SUMIF(range, criteria, sum range)


To sum up only negative numbers: =SUMIF(A1:A10,"<0")

=SUMIF(A1:A10,">0",B1:10) sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.

See COUNTIF() for syntax examples that can be used with SUMIF().

Trademarks | IBM Connections wiki