Distribute sales - Formulas In Excel - Microsoft Excel Tutorials

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

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

Watch the Video Tutorial - https://www.youtube.com/watch?v=wORM9IycFB4

  Hope You Like This Tutorial - Give Comments