SUMIF
to sum numbers in a cells range that have met a condition
range 1：a range tested against criterion [and summed if there’s no range 2]
criterion：a condition applied to range 1
- if you’d like to sum the amount of sales from carrot, the criterion is “carrot”.
- if you’d like to sum the amount of sales more than $5, the criterion is “>5”
[range 2 to sum]：a range to be summed if there’s a different range to sum.
- size of range 1 and 2 must be equal.
- if not set, range 1 is considered a range to be both summed and tested against a criterion.
※ if a condition is unclear, wildcard can be set.
※If criterion contains a text and logical operators( such as “=”, “<"),
it must be enclosed in double quotation marks, like “apple”, “>5”.
Example
Sum all the sales amount greater than $5 within the thick blue border.
Answer
$19.5
1, Select the cell D10 and type =SUMIF().
2, Define the cell range D2:D7 as “range 1”.
3, Define “>5″(greater than $5) as the criterion
[range 2 to sum]：a range to be summed if there’s a different range to sum.
Step # 1：Examples if there is range 2 to sum
SUMIF ( range 1, criterion, range 2 to sum）
Example 1
If you want to sum the sales amounts for “Carrot”, range 1 where the criterion is supplied is on Column” B” (products), while range 2, to be summed, is on Column “D” (sales).
Example 2
Suppose you want to sum the sales amounts if the number of “Qty. Sold” are greater than equal to (>=) 5, range 1 is on Column” C” (Qty. Sold), while range 2 to be summed is on Column “D” (sales).
