Microsoft Excel Functions & Formulas

Use the SUMIF function to determine sales

of a team

In this example, all the sales of different teams have to be summed

up. You can use the SUMIF function to add all cells in a range, spec-

ified by a given criteria.

SUMIF(range, criteria, sum_range)

range: A range of cells to be evaluated.

criteria: The criteria that specifies which cells to add. This can

be a number, expression, or text.

sum_range: The actual cells to be summed.

4

To sum specified data:

1. In cells A2:A10 enter a team number from 1 to 3.

2. List all team members in cells B2:B10.

3. In cells C2:C10 enter the daily sales of each employee.

4. List the numbers 1, 2, 3 for each team in cells ...