Sumif Function in Excel

Prev Tutorial Next Tutorial

Sumif Function in Excel

The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function.


=SUMIF(range,criteria, [sum_range]) 

SUMIF function has three main parts;

Range: It refers to range of cells that you want to evaluate to shortlist the cells that meet the given criteria.

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

Sum _range: It provides the actual cells that are to be added. It is an optional argument. If we omit this part of the function the SUMIF function treats "range" as "sum_range" thus adds the cells of the range argument.

See in Below example:

The company wants to know the total salary of the HR department. In this case, by applying the SUMIF function the company can add the salaries of all employees of HR department. You can see in below image.

sumif function in excel


Download Projects

Google Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Advertisements