Article updated on January 17, 2018

Excel function syntax

SUMIF(range, criteria, [sum_range])

The SUMIF function sums values based on a condition. The condition can be applied to the values being summed or to corresponding values in another column.

Arguments

range Required. The cell range you want to check the condition against.
criteria Required. A single condition to filter values you want to sum.
[sum_range] Optional. The sum_range argument allows you to apply a condition to corresponding values.

Comments

You are allowed to use logical operators like:

  • < less than
  • > greater than
  • = equal to
  • <= less than or equal to
  • >= greater than or equal to

You also have the option to use an asterisk * to perform wildcard operations and a question mark ? to match a single character.

If you need to apply multiple conditions or criteria I recommend the SUMIFS function.

Examples using wildcards and question marks

The wildcard character * allows you to match one to multiple characters and the question mark matches a single character.

Download excel *.xlsx file

SUMIF function explained.xlsx