SUMIF()
Sums the cells in a range that meet a single condition.
SUMIF(range, criteria, [sum_range])SUMIF checks each cell in range against criteria, and for every match, adds the corresponding cell in sum_range. If you omit sum_range, it sums range itself.
criteria supports comparisons (">100"), wildcards ("North*"), and cell references (">="&D2).
Arguments
- range
- The range to test against criteria.
- criteria
- The condition that decides which cells to include.
- sum_rangeoptional
- The range to sum when criteria matches. Defaults to range if omitted.
Examples
=SUMIF(A2:A20, "North", C2:C20)→18,400
Sums column C wherever column A says North.
=SUMIF(B2:B20, ">100")→9,340
Sums only the values in B2:B20 that are over 100.