SUMIF
Sums cells that meet a criteria.
| Category | Aggregate |
| Syntax | SUMIF(range, criteria, [sum_range]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
range | Required | The range of cells to evaluate against the criteria. |
criteria | Required | The criteria in the form of a number, expression, or text that defines which cells will be added. |
sum_range | Optional | The actual cells to sum. If omitted, the cells in range are summed. |
Example
SUMIF(A1:A10, ">5") // Sum values greater than 5
SUMIF(A1:A10, ">5", B1:B10) // Sum B where A > 5
Auto-generated from the EngCanvas function registry.