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). 
Was this article helpful?
YesNo