SUMIF Function

Adds numbers within a range that meet a specified condition.
Sample Usage
SUMIF(Quantity:Quantity, >25, Cost:Cost)
  • range
  • criterion
  • [
  • range
    The group of cells to evaluate.
  • criterion
    The condition that defines which numbers to add (for example: 15, "Hello World!", >25).
  • sum_range
    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). 

This example references the following sheet information:

  Clothing Item Transaction Total Units Sold Price Per Unit Sold Date
1 T-Shirt 1,170.00 78 15.00 02/12/19
2 Pants 1,491.00 42 35.50 02/15/19
3 Jacket 812.00 217 200.00 03/20/19

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

Formula Description Result
=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.00 2,303.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