Microsoft Excel Functions & Formulas

Distribute sales

In a company each sale is assigned to a particular salesperson. The

sale of 30 pieces totals $199,000. Each salesperson sold an individ-

ual amount of goods. Calculate the corresponding sales for each

person.

4

To calculate the total amount of sales for each employee:

1. Select cell B1 and enter the total amount of sales: 199000.

2. Select cell C1 and enter the total amount of sold goods: 30.

3. In columns A and B, enter the names of the salespeople and

the number of pieces they sold.

4. Select cells C5:C11 and type the following formula:

=B5*$B$1/$B$2.

5. Press <Ctrl+Enter>.

Note: Check out the AutoSum of the selected range in the

status ...