Excel

Hi Rachel

Thank you for your question.

To figure out a percentage, you normally create a total first, e.g. if region A sells 45000 units, region B sells 40000 and region C sells 35000, then the total of region A + region B + region C = 120000.

So region A's percentage of the total sales =45000/120000 - say if these amounts are entered into cells A1 and A4 on the spreadsheet, the formula would be =A1/A4

Then once you have created the formula, format the cell with the formula in it as a percentage. This will multiply the result by 100 for you and add a % sign.

I hope this helps.
Amanda