HomeExcel Functions ► Excel SUMIF Function

Syntax For Excel SUMIF Function

What is the use of Excel SUMIF Function?

Use Excel SUMIF Function to SUM numbers from a range which meets specified criteria. In simple words, you can define a range to check for criteria & a corresponding range of values which you want to sum.

Syntax for Excel SUMIF Function

SUMIF(range, criteria, [sum_range])

range A range of cells from which you want to check for criteria. [Required]

criteria A criteria which can be a number, text, expression, cell reference or a function. [Required]

[sum_range] A cell range which has the values you want to sum. [Optional]

More Information on Excel SUMIF Function

  • The size of criteria range & SUM range does not have to be same. It will always consider cells according to criteria range.
  • You can also use Wildcard Characters in the sumif function.
  • You can only able to sum values on the basis of a single criterion. And, if you want to define more than one criteria you can use SUMIFS Function for that.
  • If you want to specify criteria in the form of text, you have to use double quotation marks.
  • If you skip specifying SUM range it will SUM the values from criteria range which meet the criteria.
  • You can only specify criteria up to 255 characters.

Examples to understand Excel SUMIF Function

Examples For Excel SUMIF Function

In above example, I have specified A1:A9 as criteria range & B1:B9 as sum range & I have specified the criteria in A12 which has the value C. And, the total for the product C is 20 units (12+8). You can also insert criteria directly into the function.

Examples For Excel SUMIF Function With Wildcards

As I have already mentioned that you can use Wildcard Character in the sumif function. In above example, I have used an asterisk to specify a criterion which has an alphabet “S”.

Examples For Excel SUMIF Function Without Sum Range

If you skip specifying the sum range it will give you the sum of criteria range. But, that will only possible if criteria range has numeric values.

Download Sample File

Download Sample File To Learn Excel SUMIF Function

More Tips Related With Excel SUMIF Function


Use Excel SUMIF Function to sum values based on the criteria. Learn more about SUMIF from here.

Related Function

CountIf | SumIfs | Sum | AverageIf

Blog | Excel Functions