Percentage change, percent of total and running totals
Updated · Works in: all current Excel versions, Google Sheets · Every example checked before release
Short answer
Percentage change is =new/old-1 (format as %), and it's not meaningful when the old value is 0 or negative. Percent of total is =C2/$C$12, with the total cell locked. A running total is =SUM($C$2:C2) filled down: the start stays put, the end moves.
Growth, shares and running totals are three of the most common things a report shows. Each is a one-line formula once you know the pattern.
Percentage change
Change is new ÷ old − 1: =C2/B2-1. Format the cell as a percentage. (C2-B2)/B2 is the same thing.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | 2025 | 2026 | vs 2025 |
| 2 | Jan | $18,400 | $20,100 | 9.2% |
| 3 | Feb | $17,200 | $19,850 | 15.4% |
| 4 | Mar | $21,000 | $23,400 | 11.4% |
| 5 | Apr | $19,800 | $22,900 | 15.7% |
| 6 | May | $22,500 | $21,700 | -3.6% |
| 7 | Jun | $24,100 | $26,800 | 11.2% |
Round the value, not just the look
A 0% format shows 0.0756 as 8% but still calculates with 0.0756. To change the value, round it: ROUND(3.14159, 2) is 3.14, ROUNDUP(2.01, 0) is 3 and ROUNDDOWN(2.99, 0) is 2. Functions nest, inside first: ROUND(AVERAGE(F2:F13), 1) averages, then rounds to one decimal.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Product | Category | Qty | Price | Status | Avg qty | 2.4 | |
| 2 | 1001 | 2 Mar 2026 | Mara Okafor | Monstera | Plants | 1 | $34.00 | Shipped | |||
| 3 | 1002 | 2 Mar 2026 | Jonas Lind | Terracotta pot | Pots | 3 | $12.50 | Shipped | |||
| 4 | 1003 | 3 Mar 2026 | Priya Raman | Snake plant | Plants | 2 | $22.00 | Shipped | |||
| 5 | 1004 | 4 Mar 2026 | Tomás Ruiz | Watering can | Tools | 1 | $18.00 | Pending | |||
| 6 | 1005 | 5 Mar 2026 | Elif Demir | Fern | Plants | 4 | $9.50 | Shipped | |||
| 7 | 1006 | 5 Mar 2026 | Mara Okafor | Potting mix | Soil | 2 | $7.25 | Returned | |||
| 8 | 1007 | 6 Mar 2026 | Kenji Mori | Pruning shears | Tools | 1 | $24.00 | Shipped | |||
| 9 | 1008 | 7 Mar 2026 | Ines Varga | Ceramic pot | Pots | 2 | $19.00 | Pending | |||
| 10 | 1009 | 8 Mar 2026 | Jonas Lind | Monstera | Plants | 1 | $34.00 | Shipped | |||
| 11 | 1010 | 9 Mar 2026 | Sofia Rossi | Fern | Plants | 6 | $9.50 | Shipped | |||
| 12 | 1011 | 10 Mar 2026 | Priya Raman | Potting mix | Soil | 5 | $7.25 | Shipped | |||
| 13 | 1012 | 11 Mar 2026 | Leo Brandt | Snake plant | Plants | 1 | $22.00 | Pending |
Percent of total
Divide each value by the total, and lock the total with $ so it doesn't slide when you fill down.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Type | Budget | Actual | Share |
| 2 | Rent | Fixed | $1,200.00 | $1,200.00 | 46.5% |
| 3 | Groceries | Variable | $450.00 | $512.40 | 17.4% |
| 4 | Utilities | Fixed | $160.00 | $148.75 | 6.2% |
| 5 | Transport | Variable | $120.00 | $96.50 | 4.6% |
| 6 | Phone & internet | Fixed | $65.00 | $65.00 | 2.5% |
| 7 | Eating out | Variable | $150.00 | $203.10 | 5.8% |
| 8 | Subscriptions | Fixed | $38.00 | $44.97 | 1.5% |
| 9 | Gym | Fixed | $40.00 | $40.00 | 1.5% |
| 10 | Gifts | Variable | $60.00 | $25.00 | 2.3% |
| 11 | Savings | Fixed | $300.00 | $300.00 | 11.6% |
| 12 | Total | $2,583.00 |
Running total
An expanding range adds everything from the first row to the current one: =SUM($C$2:C2). Only the start is locked.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | 2025 | 2026 | 2026 to date |
| 2 | Jan | $18,400 | $20,100 | $20,100 |
| 3 | Feb | $17,200 | $19,850 | $39,950 |
| 4 | Mar | $21,000 | $23,400 | $63,350 |
| 5 | Apr | $19,800 | $22,900 | $86,250 |
| 6 | May | $22,500 | $21,700 | $107,950 |
| 7 | Jun | $24,100 | $26,800 | $134,750 |
Check yourself
One real exercise from the “Ranges and functions” unit. Checked on our server; no account needed.Show how far each category was over or under budget in E2: Actual (column D) minus Budget (column C). Positive means overspent, negative means under budget. Fill down to E11.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Type | Budget | Actual | Over/under |
| 2 | Rent | Fixed | $1,200.00 | $1,200.00 | |
| 3 | Groceries | Variable | $450.00 | $512.40 | |
| 4 | Utilities | Fixed | $160.00 | $148.75 | |
| 5 | Transport | Variable | $120.00 | $96.50 | |
| 6 | Phone & internet | Fixed | $65.00 | $65.00 | |
| 7 | Eating out | Variable | $150.00 | $203.10 | |
| 8 | Subscriptions | Fixed | $38.00 | $44.97 | |
| 9 | Gym | Fixed | $40.00 | $40.00 | |
| 10 | Gifts | Variable | $60.00 | $25.00 | |
| 11 | Savings | Fixed | $300.00 | $300.00 |
Common mistakes
Dividing by the new value instead of the old one.
Forgetting the
$on the total, so every row below divides by an empty cell (#DIV/0!).Calling a change from 2% to 3% “1% growth”: it's 1 percentage point, or 50% growth.
Questions
How do I show a decrease as negative?+
new/old−1 is already negative for a decrease. Use a format like 0.0%;-0.0% or conditional formatting to colour it.
What if the old value is 0 or negative?+
Then a percentage change isn't meaningful: dividing by 0 gives #DIV/0!, and growth from −400 to +300 would show as −175%. Finance reports show "n/m" (not meaningful): =IF(B2<=0,"n/m",C2/B2-1).
Reading is step one. Now make it stick.
Practise it in a five-minute lesson on a live sheet, with instant feedback. No account needed for the free units.