How to Calculate Percent of Total in Excel
Each row as a share of the column means copying =B2/SUM($B$2:$B$99) down — and the moment your data grows past the anchored range, the percentages quietly stop adding up. Here's why, and the one-click way, rounded to your decimals.
Last updated: August 2026
| Value | % of total | |
|---|---|---|
| 25 | → | 25% |
| 75 | → | 75% |
Why the anchored divide breaks
The usual formula is =B2/SUM($B$2:$B$99) copied down, with the denominator range pinned by dollar signs and the cell formatted as a percentage. It's fragile in two ways: pin the range too tight and new rows below $B$99 are left out of the total; insert or delete rows and the anchored SUM shifts off your data. Either way the shares no longer add to 100%, and you've a stray ROUND to bolt on top to get clean figures.
The 1-click way — Tellsheet's Percent of Total
Select the numeric column and run Percent of Total. It divides every row by the true column total and writes each row's share as a percentage, rounded to the decimals you choose — no anchored SUM, no separate ROUND. The output is real numbers you can chart. Pairs with Cumulative Percent and Running Total.
Frequently asked questions
How do I calculate percent of total in Excel?
Manually it's =B2/SUM($B$2:$B$99) copied down and formatted as a percentage. Percent of Total adds the column in one click, rounded to your decimals.
Why does the anchored SUM formula break?
The pinned range is fixed to set rows, so growing or reshuffling your data leaves the total off, and the shares stop summing to 100%.
Can I control the decimals?
Yes — you set the decimal places, so you get clean figures like 25% or 24.7% without a separate ROUND.
Do the percentages add up to 100?
Each value is divided by the true column total, so shares sum to 100% before rounding — as with any percentage split, rounding can leave a tiny visual difference.
Related Excel guides
Get percent of total in one click
Percent of Total divides each row by the real column total and rounds to your decimals — no anchored SUM to babysit.
Get Tellsheet free See pricing