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 - The cell range you want to check the condition against

criteria - A single condition to filter values you want to sum

[sum_range] - This argument is 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