Excel > Excel 2007 Intermediate > More Advanced Functions

Excel SumIf Function

The SUMIF function totals the values of a range that meet specific criteria. For example it will total only the orders from a specific company or after a specific date.

The syntax for SUMIF is:

=SUMIF(range, criteria, [sum_range])




The range of cells to evaluate.


The condition that defines which cells are to be added.

Sum range

The actual cells to sum. If omitted the values in range are added.

The example below demonstrates SUMIF being used to sum the total sales of wardrobes.

Using the SumIf function

Follow us on

Facebook  Twitter  You Tube