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:
=sumif(E5:E13,”5″,H5:H13)
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.