SUMIFS
Returns the sum of all cell values which meet multiple criteria.
Syntax
=SUMIFS(SumRange, CriterionRange1, Criterion1, [CriterionRange2,...], [Criterion2,...])
Arguments
| Name | Type | Description |
|---|---|---|
| SumRange | Range | Cell-range to calculate sum for. |
| CriterionRange1 | Range | The cell-range which is checked against the criterion. |
| Criterion1 | String | The criterion each cell of CriterionRange1 has to fulfill. |
| CriterionRange2,... (optional) | Range | Additional cell-range which is checked against next criterion. |
| Criterion2,... (optional) | String | Additional criterion each cell of CriterionRange2 has to fulfill. |
Return
| Type | Description |
|---|---|
| Number | The sum of cell values which meet all specified criteria. |
Examples
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 230000 | Freiburg | 3 | No |
| 2 | 197000 | Cologne | 2 | Yes |
| 3 | 345678 | Cologne | 4 | Yes |
| 4 | Freiburg | 321900 | 2 | Yes |
| 5 | Cologne | 203000 | 3 | No |
| Formula | Result | Comment |
|---|---|---|
| 745678 | Total price of all available houses in Cologne. |
| 230000 | Total price of all available houses in Freiburg which have more than 2 rooms. |