Write the formula to calculate the Total Sales of North Zone
Answers
1
Open a new spreadsheet in Microsoft Excel.
2
Enter the name, or type, of your first item in cell A1. As an example, you might enter "Action figures."
3
Enter the total sales from the first item in cell B1. If you derived $15,000 from action figures sales, you would enter "$15,000" in cell B1.
4
Repeat this process for each item, or type of item, on a new line. In the example, if you only sold action figures and toy cars, you would enter "Toy cars" in cell A2 and its total sales, such as "$1,000," in cell B2.
5
Enter "=sum(B1:B#)" in the next empty cell in the B column, and replace "#" with the row number of the last filled cell in column B. In the example, you would enter "=sum(B1:B2)" in cell B3 to calculate the total sales of the two items.
6
Type "=item_sales/total_sales" in the C column for each item row. Replace "item_sales" with the individual item's sales and "total_sales" with the reference to the cell you filled out in the previous step. In the example, you would enter "=B1/B3" in cell C1 and "=B2/B3" in cell C2.
7
Right-click the "C" column header and select "Format Cells." Click "Percentage from the Number tab and click "OK" to format the results as a percentage. The data in column C will then display the percent of total sales for each item.