SUMIF Function

Adds numbers within a range that meet a specified condition.
Sample Usage
SUMIF(Quantity:Quantity, >25, Cost:Cost)
Syntax
SUMIF(
  • range
  • criterion
  • [
    sum_range
    ]
)
  • range
    The group of cells to evaluate.
  • criterion
    The condition that defines which numbers to add (for example: 15, "Hello World!", >25).
  • sum_range
    —[optional]
    The group of cells to add, if different from the range.
Usage Notes
  • For criterion, acceptable operators include: = (equal to), <> (not equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to). 
Examples

This example references the following sheet information:

 Clothing ItemTransaction TotalUnits SoldPrice Per UnitSold Date
1T-Shirt1,170.007815.0002/12/19
2Pants1,491.004235.5002/15/19
3Jacket812.00217200.0003/20/19

Given the table above, here are some examples of using SUMIF in a sheet:

FormulaDescriptionResult
=SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM Transaction Total if Price Per Unit is greater than 20.003,115.00
=SUMIF([Clothing Item]1:[Clothing Item]3, "Pants", [Units Sold]1:[Units Sold]3)Units Sold based on Item. SUM Units Sold, if Clothing Item equals “Pants”.42
=SUMIF([Sold Date]1:[Sold Date]3, MONTH(@cell) = 2, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM Transaction Total, if the Sold Date’s Month is 2 (February). 2,661.00
Was this article helpful?
YesNo