Excel + Google Sheets · % of total
The $ that saves your formulas
Press F4 to add $ and lock a range so it doesn't move when you drag.
The formula
=B2 / SUM($B$2:$B$5)What each part means
B2Moves with each row$B$2:$B$5Locked with $ (F4)
Example
| A | B | C | |
|---|---|---|---|
| 1 | Product | Sales | % of total |
| 2 | Planner | 500 | |
| 3 | Budget | 300 | |
| 4 | CRM | 150 | |
| 5 | Invoices | 50 |
| A | B | C | |
|---|---|---|---|
| 1 | Product | Sales | % of total |
| 2 | Planner | 500 | 50% |
| 3 | Budget | 300 | 30% |
| 4 | CRM | 150 | 15% |
| 5 | Invoices | 50 | 5% |
Step by step
- Click cell C2.
- Type the formula:
=B2 / SUM($B$2:$B$5) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English % of total
- Español % del total
- Português % do total