Add up the cells that meet a single condition.
Syntax
SUMIF(range, criteria, [sum_range])Arguments
rangerequired
The cells to test against the criteria.
criteriarequired
The condition, e.g. ">100" or "East".
sum_rangeoptional
The cells to add; defaults to range.
SUMIF totals values that match one criterion — for example, all sales for a single region. The criteria range and the sum range can differ. For more than one condition, use SUMIFS.
=SUMIF(B2:B100, "East", C2:C100)→$42,300Sums column C where the region in column B is East.
=SUMIF(C2:C100, ">1000")→$88,500Adds all values greater than 1000.
Set the test range
Point SUMIF at the column that holds the condition values.
Write the criteria
Use text, a number, or an operator string like ">=100".
Give the sum range
Add the column to total when it differs from the test range.
SUMIF handles one condition; SUMIFS handles multiple. SUMIFS also puts the sum range first, so the argument order differs.