SUMIFS
Sums cells that meet multiple criteria.
| Category | Aggregate |
| Syntax | SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
Parameters
| Parameter | Required | Description |
|---|---|---|
sum_range | Required | The range of cells to sum. |
criteria_range1 | Required | The first range to evaluate against criteria1. |
criteria1 | Required | The criteria to apply to criteria_range1. |
criteria_range2 | Optional | Additional range to evaluate. |
criteria2 | Optional | Criteria to apply to criteria_range2. |
Example
SUMIFS(range, criteria)
Auto-generated from the EngCanvas function registry.