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.