DISTRIBUTE SALES USING MICROSOFT EXCEL

In a company each sale is assigned to a particular salesperson. The sale of 30 pieces totals $199,000. Each salesperson sold an individual amount of goods. Calculate the corresponding sales for each person.

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

DISTRIBUTE SALES USING MICROSOFT EXCEL

Note: Check out the AutoSum of the selected range in the status bar.

Microsoft Excel Tutorials, MS Excel Tutorials, Distribute Sales using Microsoft Excel, Microsoft Excel Tutorials, Formulas in Excel, Basic Functions in Excel, Microsoft Excel Video Tutorials