What share of all the sales did each team make? It's the team's sales divided by the total.
keyboard Typing formulas is easiest on a computer with a keyboard.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Team | Sales | Share | |
| 2 | North | 609 | ||
| 3 | South | 122 | ||
| 4 | East | 531 | ||
| 5 | West | 886 | ||
| 6 | Central | 876 | ||
| 7 | Total | 3024 | ||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 |
Divide the part by the total: =B2/B7.
Excel gives an ordinary number. A cell formatted as a percentage shows that same number as 25%. The value doesn't change, only how it looks. (In Excel, the % button on the Home tab does this.)
Lock the total with $ ($B$7) so every row divides by the same total.
The basic Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example and free practice.
Know someone fighting with a spreadsheet? Send them this page.