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.

Syntax

SUMIF(range, criteria, sum range)

Example

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