Free-training-tutorial.com





Relaxing Mindfulness
Beautiful Games

Excel Basics Formulas & Functions Special Features
Format Cells Sum, Average, Countif Functions Excel Charts (Graphs)
Worksheets Quick Functions Excel Sort
Edit Cells The IF Statement Excel Filter
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Sumif Function Pivot Table
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid

Sumif Function in Excel 2007/2010 - an Easy Tutorial

Learn how to use the SUMIF function. Have a look at this free tutorial video, and if you need some more rehearsal take a look at the textual and illustrated tutorial below.
How to use the Sumif function - Watch video

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:

A table for using the sumif function

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:

=sumif(C3:C15,"Sales",D3:D15)

To sum up the salary of all workers of QA department, the function will be:

=sumif(C3:C15,"QA",D3:D15)

Another example:
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:

=sumif(B3:B15,">35",D3:D15)

Have a look at the tutorial video above to see an animated illustration of this subject.