Sumif Function in Excel - an Easy Tutorial
The sumif function enables you to sum up only some specific cells in a column, cells which confirm to some condition.
Have a look at the following worker's salary table:
Let's for example, sum up the salary of all the workers who belong to the "Sales" department.
The sumif function consists of three parts separated by commas:
1. A range
2. A condition to apply to that range
3. The range of cells to sum up
In our example, the sumif will look literally something like this:
=sumif ( The Department column, is "Sales"? , The Salary column)
And the function will actually be:
To sum up the salary of all workers of QA department, the function will be:
Let's sum up the salary of all workers that are older than 35.
The function in words:
=sumif ( The Age column, is older than 35, The salary column)
And the actual function will be:
Have a look at the tutorial video above to see an animated illustration of this subject.