How Percentage Distribution Works
Learn how percentage distribution works, how to calculate each category’s share of a total, and how to check whether your percentages are correct.
A budget spreadsheet lists five spending categories, and someone rounds each one to the nearest whole percent. Add them up and the total comes to 99% or 101%, not 100. Nobody made an arithmetic mistake — that's just what rounding does to a percentage distribution, and it's one of several small details that trip people up when breaking a total into parts.
Breaking a total into shares
Percentage distribution shows how a total is divided among categories, with each category's share expressed as a percentage of the whole. It's the calculation behind budget breakdowns, sales-by-product reports, survey results, and any pie chart you've ever seen.
The formula
Category Percentage = (Category Value ÷ Total) × 100
This is the same "part of a whole" calculation as our 's "X% of Y" mode, just run once per category using a shared total.
A product sales example
A shop sells 1,000 units total across four products in a month: Product A sold 400, B sold 300, C sold 200, D sold 100.
| Product | Units sold | Share of total |
|---|---|---|
| A | 400 | 40% |
| B | 300 | 30% |
| C | 200 | 20% |
| D | 100 | 10% |
| **Total** | **1,000** | **100%** |
Each row: units ÷ 1,000 × 100. Product A: 400 ÷ 1,000 × 100 = 40%, and so on.
A household spending example
A monthly budget of $4,000 breaks down as: Housing $1,600, Food $800, Transportation $600, Savings $500, Other $500.
| Category | Amount | Share of total |
|---|---|---|
| Housing | $1,600 | 40% |
| Food | $800 | 20% |
| Transportation | $600 | 15% |
| Savings | $500 | 12.5% |
| Other | $500 | 12.5% |
| **Total** | **$4,000** | **100%** |
Why totals usually equal 100%
When every category is mutually exclusive and together they account for the entire total — as in both examples above — their percentages are mathematically guaranteed to sum to 100%, because each category's value divided by the same total, added back up, just reconstructs the whole divided by itself.
When percentages can exceed 100%
That guarantee only holds when categories don't overlap. If a survey asks "which of these features do you use?" and respondents can select more than one, the percentages for each feature are each calculated against the total number of respondents — but since people can appear in multiple categories, the percentages can add up to well over 100%. That's not an error; it reflects that the categories aren't mutually exclusive, and each percentage should be read on its own rather than expecting them to sum neatly.
Rounding, and why it matters
Individually rounding each percentage can make a distribution's total drift slightly away from 100%. Three categories that are each genuinely 33.33% will individually round to 33%, and 33% × 3 = 99%, not 100% — the "missing" 1% didn't disappear, it was lost across three separate rounding steps. This is expected and not a calculation error, but it's worth flagging in a report ("totals may not sum to 100% due to rounding") rather than silently adjusting one number to force a clean total.
Distribution vs. percentage change
It's easy to conflate percentage distribution with percentage change, but they answer different questions. Distribution asks "what share of the current total does this category represent, right now?" Percentage change asks "how did a value move between two points in time?" A product going from a 40% share last quarter to a 45% share this quarter combines both ideas — the distribution changed, and you could separately calculate the percentage change in that share (a 12.5% relative increase in market share, even though it's only a 5 percentage point move — see for that distinction).
Frequently Asked Questions
Try it yourself
Use the Percentage Calculator to run this calculation with your own numbers.