Description Returns the sum of the specified cells based on the given criteria.
Syntax SUMIF ( range, criteria, sum_range)
| Argument | Description |
|---|---|
| range | The range of cells you want evaluated. |
| criteria | A number, expression, or text that defines which cells are added. For example, criteria can be expressed as 15, "15", ">15", "cars". |
| sum_range | The actual cells to sum. These cells are only summed if their corresponding cells in range match the criteria. If this argument is omitted, the cells in range are summed. |
See Also AVERAGE, COUNT, COUNTA, COUNTIF, PRODUCT, SUM
