Why percentages don’t add up to 100% — and how to fix it

Percentages usually fail to add to 100% because each one was rounded separately. Three equal shares are 33.33% each, which round to 33%, totalling 99%. Other causes are answers that overlap, such as “tick all that apply”, and figures taken from different totals. Rounding gaps are normal and can be fixed or footnoted.

Cause 1: rounding each figure separately

Each rounding can move a figure by up to half a unit. Across several categories, those small errors can push the total above or below 100.

• Three equal parts: 33.33 + 33.33 + 33.33 → 33 + 33 + 33 = 99%.
• Shares of 12.5%, 12.5%, 37.5% and 37.5% round half-up to 13 + 13 + 38 + 38 = 102%.

Neither figure is wrong; each is the nearest whole number to the truth. The total is simply not the rounded value of the true total.

The fixes

• Show a decimal place. 33.3 + 33.3 + 33.3 = 99.9% is close enough that readers rarely notice. More decimals shrink the gap further.
• Add a note such as “Figures may not total 100% because of rounding.” This is standard in published statistics.
• Use the largest remainder method when the total must be exactly 100 — for a pie chart label or a budget split. Round every figure down, see how many points are missing, then give one point each to the figures with the largest leftover decimals.

Largest remainder, worked through

Shares of 45.6%, 30.3% and 24.1%:

1. Round down: 45 + 30 + 24 = 99. One point is missing.
2. Leftovers: 0.6, 0.3 and 0.1. The largest is 0.6.
3. Give it the point: 46 + 30 + 24 = 100.

Never force the total by adjusting whichever figure is easiest, or always the last one. That biases one category every time.

Cause 2: answers that overlap

In a “choose all that apply” question, one person can count in several categories. If 70% use email and 60% use chat, the total is 130%, and that is correct: each percentage is a share of people, and people were allowed more than one answer. Do not rescale such figures to 100%; say that respondents could pick more than one option.

Cause 3: different totals

Percentages only add up when they share one base. “40% of men and 60% of women” is not 100% of anything. Nor is “15% of sales in Q1 and 25% in Q2” if each is a share of its own quarter. To combine them, go back to the counts.

In spreadsheets and charts

Spreadsheets add to the confusion because a cell formatted to show 33% still holds 33.333…. The column total is calculated from the hidden decimals, so it shows 100% even though the visible figures add to 99%. Readers who check with a calculator then think the sheet is wrong. Either show one more decimal place, or round each cell with a ROUND() formula and apply the largest remainder adjustment so the visible figures and the total agree. Chart tools behave the same way: pie slice labels are rounded individually, so the labels on a pie can total 99% or 101% while the slices themselves are exact.

Cause 4: something is missing

A total of 92% may mean a category was left out: “other”, “don’t know”, or blanks. If rounding cannot explain a gap of more than about half a point per category, look for a missing group or a wrong base. The Percentage Calculator shows each “X is what percent of Y” with the working, which makes a missing category obvious; the Scientific Calculator is handy for totalling the raw counts first.

How big a gap is normal?

With whole-number rounding, the total can be off by up to half a point times the number of categories, though in practice it is usually within one or two points. Five categories rounding to 98% or 102% is plausible; 90% is not a rounding problem.

Mistakes to avoid

• Rounding intermediate results, then calculating more percentages from them.
• Squeezing multi-answer results into a pie chart; use a bar chart instead.
• Quietly editing one figure so the column totals 100.

Checklist

• Same base for every figure?
• Could one person or item count twice?
• Gap small enough to be rounding? Add a footnote or one decimal.
• Must total exactly 100? Use the largest remainder method.