SUMIF
Returns the sum of all cell values in a cell-range which meet a given criterion. To specify multiple criteria please use SUMIFS.
Syntax
=SUMIF(DataRange, Criterion, [SumRange])
Arguments
Name | Description |
---|---|
DataRange | Cell-range to calculate sum for. |
Criterion | The criterion each cell has to fulfill. |
SumRange | Optional. If given these cells are used to calculate total sum. If ommitted DataRange is used. |
Return Value
The sum of all cell values which meet criterion.
Example
A | B | |
1 | 100000 | 200 |
2 | 200000 | 400 |
3 | 300000 | 400 |
4 | North | 600 |
5 | East | 800 |
6 | South | 1000 |
Function | Result | Comment |
---|---|---|
SUMIF(A1:A3, "250000") | 300000 | Only cells A1 and A2 match given criterion. |
SUMIF(A1:A6, "=*th", B1:B6) | 1600 | Take cells from colum A which end with "th" and average corresponding values from column B. |