SUMIFS
Returns the sum of all cell values which meet multiple criteria.
Syntax
=SUMIFS(SumRange, CriterionRange1, Criterion1, [CriterionRange2,...], [Criterion2,...])
Arguments
| Name | Description |
|---|---|
| SumRange | Cell-range to calculate sum for. |
| CriterionRange1 | The cell-range which is checked against the criterion. |
| Criterion1 | The criterion each cell of CriterionRange1 has to fulfill. |
| CriterionRange2,... (optional) | Additional cell-range which is checked against next criterion. |
| Criterion2,... (optional) | Additional criterion each cell of CriterionRange2 has to fulfill. |
Return
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. |