Excel > Excel 2003 Intermediate > More Functions

SumIf

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])

Argument	Purpose
Range	The range of cells to evaluate.
Criteria	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.

Nested functions CountIf

Guides