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`)

`range` is the range to which the criteria are
to be applied.
`criteria` is the cell in which the search criterion
is shown, or the search criterion itself. If the criteria is written
into the formula, it must be surrounded by double quotation marks.
Criteria can also include wildcard characters. To represent any single
character, use ? (question mark) in the text that specifies the condition.
To represent any number of consecutive characters, use * (asterisk).
For example, use B* to match all entries that begin with B, and B???
to match all entries that begin with B and contain three other characters.
To represent an actual question mark or asterisk, use ~ (tilde) to
precede the ? or *.
`sum range` is the range from which values are
summed. If this parameter has not been indicated, the values found
in the range are summed.

## 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().