Excel > Excel 2003 Intermediate > More Functions


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.

SumIf counting sales of wardrobes

Follow us on

Facebook  Twitter  You Tube