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