How to Compute Cumulative Percentage (With Excel Examples)

AvatarByEric Dawson Computers & Software

To compute cumulative percentage, divide the running total of your counts by the grand total, then multiply by 100. Written out, the formula is cumulative percentage = (cumulative frequency / total frequency) x 100. Work down the table one row at a time, adding each new count to everything above it, and divide every running total by that same grand total. Done properly, the last row lands on exactly 100 percent, which is the fastest check that nothing was missed or counted twice. In Excel, one formula such as =SUM($B$2:B2)/SUM($B$2:$B$11) fills the whole column.

What Cumulative Percentage Means

Cumulative percentage is the share of all observations that sit at or below a given value, on a scale that ends at 100. Automate Excel describes it as the percentage of the occurrences of an event and the events below it, measured against the total number of events.

Think of it as a running share rather than a single slice. A plain percentage tells you how much of the total one category holds, while the cumulative version tells you how much that category plus everything before it holds. Because every category is eventually added in, the bottom row of a cumulative column always reads 100 percent, and Calculator Academy, Automate Excel and Spreadsheet Planet all treat that as the built-in accuracy check.

Cumulative Frequency, the Number You Need First

Cumulative frequency is the running total of the individual counts up to and including the current row. Add the first row’s count to the second row’s count for the second cumulative figure, add the third row to that result, and keep going to the bottom of the table.

Order matters here, because a running total only means something when the rows sit in a sensible sequence, usually smallest value to largest. Once the final cumulative frequency equals the sum of every individual count, the column is correct and ready to convert.

How to Compute Cumulative Percentage by Hand

Divide each cumulative frequency by the total frequency, then multiply by 100, working from the top row down. No special function is needed, no software, and no rounding until the very last step.

  1. Order the rows. Sort the values or classes from low to high so the running total moves in one direction only.
  2. Total the counts. Add every individual frequency together to get the total frequency, which Calculator Academy labels O, the number of observations.
  3. Build the running total. Carry the first frequency down as the first cumulative frequency, then add each new count to the figure directly above it.
  4. Divide and scale. Take each cumulative frequency, divide it by the total frequency, and multiply the answer by 100.
  5. Check the bottom row. That final value has to be exactly 100 percent; anything else means a count went missing or was added twice.

Written as a formula, the whole procedure is CP = CF / O x 100, where CP is the cumulative percentage, CF is the cumulative frequency, and O is the total number of observations. Calculator Academy uses that notation. Automate Excel and Statology express the same relationship as cumulative frequency divided by total frequency, multiplied by 100, which is the identical calculation with different labels.

A Worked Example with Snow Days

Sciencing runs the arithmetic on two months of weather: 10 snowy days in January and 15 in February, so 25 snowy days in total. January contributes 31 days and February contributes 28 in that example, giving a combined sample of 59 days.

Dividing 25 by 59 gives 0.4237, which becomes 42.4 percent once it is multiplied by 100 and rounded to one decimal place. Across the two months together, then, snow fell on roughly 42 percent of days. Sciencing frames the method as three moves: sum the occurrences, sum the sample sizes, and divide the first by the second before converting to a percentage.

That example is worth noticing for a second reason. It shows that the two months cannot simply have their individual percentages averaged, since January had 31 days and February only 28. Cumulative work always goes back to raw counts and one shared denominator.

Step by Step on a Frequency Table

A frequency table makes the running total easy to see, because each row carries its own count while the cumulative column grows alongside it. The sample below holds 200 customer satisfaction ratings on a 1 to 10 scale, the same shape of data Automate Excel uses in its worked example, with counts picked here to keep the arithmetic clean.

Rating Frequency Cumulative frequency Cumulative percentage
1 4 4 2%
2 6 10 5%
3 10 20 10%
4 14 34 17%
5 22 56 28%
6 28 84 42%
7 34 118 59%
8 40 158 79%
9 26 184 92%
10 16 200 100%

Row 6 says that 84 of the 200 ratings came in at 6 or lower, which is 42 percent of the sample. Look at row 8 and you get 79 percent at or below a score of 8, so just over a fifth of these customers handed out a 9 or a 10. Note that the frequency column never becomes percentages itself; the conversion happens once, at the division step, and the cumulative column does the rest.

How to Compute Cumulative Percentage in Excel

Excel needs one mixed reference to do the work: =SUM($B$2:B2) expands the running total as it is copied down, and dividing that by the fixed grand total turns it into a cumulative percentage. Spreadsheet Planet sets out three ways to arrange that, and all three return identical numbers.

The layout used below puts values in column A, counts in column B across rows 2 through 11, and the grand total in cell B12 using =SUM(B2:B11). Change the row numbers to match your own sheet, but leave the dollar signs exactly where they are, since they are what makes one end of the range stay put while the other end travels.

Method 1: The Helper Column

A helper column splits the job in two, which makes it the easiest version to audit. Statology and Automate Excel both teach this order.

  1. Cumulative frequency. In C2 enter =SUM($B$2:B2) and copy it down to C11. The anchored $B$2 holds the top of the range while the loose B2 slides down, so each row sums a little more.
  2. Cumulative percentage. In D2 enter =C2/$B$12 and copy it down to D11. Statology writes the same step as =C2/$C$6 in a shorter table, where the absolute reference points at the total cell.
  3. Percent formatting. Select D2:D11 and press Ctrl+Shift+% to switch the decimals to percentages. Automate Excel and Statology both use that shortcut instead of the ribbon.
  4. Decimal places. Use the Increase Decimal button on the Home tab if 42% is too blunt and you want 42.0%.

D11 must show 100% when the copy is finished. If it does not, the problem is almost always in the anchoring rather than the maths.

Method 2: One Formula, No Helper Column

One formula can replace both columns: =SUM($B$2:B2)/SUM($B$2:$B$11) in C2, copied down to C11, then formatted as a percentage. Spreadsheet Planet gives this as its second method and notes that the output matches the helper column exactly.

Read the two halves separately and it stops looking cryptic. The left SUM grows one row at a time because only its second reference is relative, while the right SUM is locked at both ends and therefore returns the same grand total on every row. Nothing here depends on a total cell existing anywhere on the sheet, which is handy when someone else keeps inserting rows under your data.

Method 3: A Pivot Table Running Total

A pivot table computes the cumulative percentage for you through the % Running Total In option, with no formula typed at all. Spreadsheet Planet recommends it for larger datasets, where dragging formulas down thousands of rows gets awkward.

Exact Menu Path in Excel for Windows

  1. Insert the pivot. Select A1:B11, then choose Insert, PivotTable, New Worksheet, and press OK.
  2. Place the fields. Drag the value field (Rating) into Rows and drag Frequency into Values, which gives Sum of Frequency.
  3. Open the settings. Right-click any number in the Sum of Frequency column and choose Value Field Settings, then open the Show Values As tab.
  4. Pick the running total. Select % Running Total In from the drop-down, set the base field to Rating, and click OK.

The column now reads as a cumulative percentage that ends at 100%, and it refreshes whenever the underlying data changes and the pivot is refreshed. Base field choice is the one setting people get wrong here, because pointing it at the wrong field produces a column that climbs in the wrong order.

Turning the Column into an Ogive Chart

An ogive is the standard chart for cumulative percentage, and Automate Excel builds it with a scatter chart using smooth lines. Highlight the value column and the cumulative percentage column, go to Insert, Charts, Scatter, and choose Scatter with Smooth Lines.

What you get is a curve that starts near zero on the left and flattens out at 100 percent on the right. Steep stretches mark where most of the data is bunched, and flat stretches mark the sparse tails. Reading a percentile off the chart is then a matter of finding the height you care about, such as 50 percent, and dropping down to the horizontal axis.

Which Excel Method to Use

Pick the helper column when someone else has to check your work, the single formula when you want a compact sheet, and the pivot table when the dataset is long or still growing. Results are the same in every case, so the decision is about maintenance rather than accuracy.

Method How it works Best for Drawbacks
Helper column Separate cumulative frequency column, then divide by the total Work that gets reviewed, teaching, spotting a bad row fast Needs an extra column and more sheet space
Single formula =SUM($B$2:B2)/SUM($B$2:$B$11) in one column Tight layouts and quick one-off analysis Less transparent, harder to verify the middle steps
Pivot table Value field set to % Running Total In Large datasets, data that keeps changing, interactive reports Data must be laid out properly, and the base field setting trips people up

Spreadsheet Planet is explicit that the three approaches agree, which is worth remembering if you inherit a workbook built a different way from your own habit. Rebuilding someone else’s method from scratch rarely pays off when the arithmetic underneath is identical.

I would choose the helper column for most everyday tables, even though the single formula is shorter. Seeing the cumulative frequency beside the percentage makes it much easier to catch an incorrect count, a broken range, or a denominator that changes as the formula is copied. The extra column uses little space, while the ability to compare the final running total with the grand total gives me more confidence in the result. I would reserve the compact formula for sheets where space matters more than easy checking.

What Cumulative Percentage Tells You About Your Data

Cumulative percentage answers one question directly: what share of the data falls at or below this point. That makes it the quickest route to percentiles, medians and threshold counts without any extra statistics.

Calculator Academy illustrates this with United States household income. In the figures it presents, households under $15,000 account for 10.3 percent cumulatively, roughly 37 percent of households earn $50,000 or less, and about 62 percent earn $100,000 or less. Its stated median of $80,610 is the income where the cumulative column crosses 50 percent, which is exactly what a median is. Those numbers were read in September 2026, and income data moves every year, so check current Census Bureau tables before quoting them anywhere that matters.

Reading Percentiles off the Column

Any percentile is just a cumulative percentage read backwards. Find the row where the cumulative column first reaches or passes 25 percent and you have the first quartile; do the same at 50 and 90 percent for the median and the 90th percentile.

Going back to the 200 ratings table, the cumulative column passes 50 percent at a rating of 7, since 6 and below only covers 42 percent while 7 and below covers 59 percent. Median rating is therefore 7. Sciencing points out a related use, tracking how a measure accumulates across time periods, which is the same calculation applied to months instead of score bands.

If Your Cumulative Percentage Does Not End at 100 Percent

A bottom row that is not exactly 100 percent means the running total and the denominator disagree, and there are only a handful of causes. Work through them in this order.

  1. Missing dollar signs. If the formula reads =SUM(B2:B2) rather than =SUM($B$2:B2), both ends of the range slide as you copy, so each row shows its own frequency instead of a running total.
  2. Wrong denominator. Dividing by a total cell that covers a different range, or one that includes the total of totals, skews every row. Check that the denominator range and the data range cover the same rows.
  3. The total row is inside the data. Including B12 in the running total range makes the last row read 200 percent, since the grand total gets counted twice.
  4. Text posing as numbers. Counts imported from another system often arrive as text and SUM ignores them silently. Values that hug the left edge of a cell are the usual clue.
  5. Blank rows in the middle. Blanks do not break SUM, but they do break a copied formula if the fill stops early. Confirm the formula reaches the final data row.
  6. Already percentages. Applying Ctrl+Shift+% to a column that holds 42 rather than 0.42 gives 4200%. Divide by 100 first, or leave the underlying value as a decimal.
  7. Rounding display only. A column showing 99.9% may really hold 99.95, which is fine. Widen the decimals to confirm before hunting for a bug.

Pivot tables have one extra failure mode of their own. When % Running Total In is set to the wrong base field, the column still ends at 100 percent but the order in between is meaningless, so check the base field before trusting any middle row.

Frequently Asked Questions

What Is the Difference Between Cumulative Frequency and Cumulative Percentage?

Cumulative frequency is a count, and cumulative percentage is that same count expressed as a share of the total. In the ratings table above, the cumulative frequency at a score of 6 is 84 and the cumulative percentage is 42 percent. One is measured in observations, the other in percent, and converting between them is a single division.

Can a Cumulative Percentage Be Greater than 100 Percent?

No, not when the calculation is correct. Every source consulted here, including Automate Excel and Spreadsheet Planet, states that the final value is exactly 100 percent, because the last cumulative frequency equals the total frequency. A figure above 100 means the running total has picked up a grand total row, a duplicated record, or the wrong denominator.

Do I Have to Sort the Data First?

Yes for meaningful results, though Excel will happily calculate on unsorted rows. Cumulative work assumes the rows run in order, normally lowest value to highest, so that “at or below” actually means something. Sorting after the formulas are in place is fine, since the running total recalculates against the new row order.

Does Excel Have a Built-in Cumulative Percentage Function?

There is no single dedicated function for it. Every method in the sources builds the result from SUM with a mixed reference, or from the pivot table setting called % Running Total In. Both routes are native Excel features, so no add-in is required.

Get the denominator right and everything else follows. Lock the top of your SUM range, divide by one grand total that covers the same rows as your data, and read the bottom cell before you read anything else, because 100 percent there is the whole quality check. Once the column is built, it does double duty as a percentile finder, which is usually worth more than the percentages themselves.

What This Page Does Not Publish

  • I do not provide personalised advice for your dataset or spreadsheet.
  • I keep this to standard cumulative percentages rather than specialised statistical methods.

References

Author Profile

Eric Dawson
Eric Dawson
I'm Eric Dawson, the writer behind The Money Watch. I live in the Columbus, Ohio area and I write about the ordinary questions that turn out to be complicated: computers, shopping, food, travel, parking, small businesses, fees, rules and products. Every article starts with the official page, the maker or the agency, then the sources that check it, and I say plainly where they disagree and what I would do. More about how I work is on the About page.