# SUMIF

Adds the cells specified by a given criteria.

**Syntax**

**SUMIF**(**range**,**criteria**,sum_range)

**Range** is the range of cells you want evaluated.

**Criteria** is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, "32", ">32", "apples".

Sum_range are the actual cells to sum. The cells in sum_range are summed only if their corresponding cells in range match the criteria. If sum_range is omitted, the cells in range are summed.

**Example**

Suppose A1:A4 contain the following property values for four homes: $100,000, $200,000, $300,000, $400,000, respectively. B1:B4 contain the following sales commissions on each of the corresponding property values: $7,000, $14,000, $21,000, $28,000.

`SUMIF(A1:A4,">160000",B1:B4)`

equals $63,000