Excel Sumif Function

The SUMIF function is used to sum up the data of some precise cells of a column; the cells which fulfilled certain conditions.

The syntax of SUMIF function is:

=SUMIF(range,criteria, [sum_range])

So, the SUMIF function has three key parts:

Range: It mentions to choice of cells that you need to calculate to choose the cells that meet the given criteria.

Criteria: It refers to situations that tell which cells are to be added. It can be a number or a text.

Sum _range: It offers the actual cells that are to be added. It is a selective argument. If we neglect this part of the function the SUMIF function treats “range” as “sum_range” thus adds the cells of the range argument.

See the following example:

The company wants to know the total incentive of business developer who generates the 5 leads. In this instance, by applying the SUMIF function the company can add the incentive of all business developers who generate the 5 leads. See the imge given below:


Range: E5:E13 is the range to be evaluated to shortlist the cells that generate the 5 leads.

Criteria: “5” is the criterion to evaluate the range or to find out the cells that are to be added.

Sum_range: H5:H13 is the sum_range that provides the actual values to be added based on the given criterion.

Please Share