Excel Formula Percentage of Total

Percent of total calculations are common in budgets, expenses, sales, and dashboards. The formula is simple: divide one value by the total and format the result as a percentage. This guide shows the pattern with an expense table.

Formula Syntax

Use this base syntax for excel formula percentage of total and replace the ranges with your own spreadsheet columns. 

part / total

Need this formula for your exact sheet?

Generate a custom excel formula percentage of total formula with your own columns, criteria, and spreadsheet layout.

Generate Free Formula

Step-by-step Example

A order research spreadsheet tracks Expense share and needs a formula-driven result instead of manual filtering.

Category Amount
Ads $400
Tools $150
Payroll $950

Resulting formula

=B2/SUM($B$2:$B$4)

The formula evaluates the Expense share rows and returns 26.67%. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.

Try It Now

The generator is pre-filled for excel formula percentage of total. Edit the prompt to match your columns, criteria, and spreadsheet layout.

You can write your request in any language. Excel formula language is selected separately.

Auto (detect from browser)

Available after free registration Sign up free

C

Available after free registration Sign up free

2

Available after free registration Sign up free

Security check required. Please complete the captcha below.

Works with SUMIFS, IF, XLOOKUP, dates, text, arrays…

Generated formula

How it works

Need more formulas every day?

HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.

  • ✓ Higher daily formula generation limits
  • ✓ Saved formula history for reuse
  • ✓ Excel formula language selection
Upgrade to Pro — $7.99/mo Sign Up Free

Common Variations

  • Percent of grand total
  • Percent of category total
  • Lock total range

FAQ

How do I set up Excel Formula Percentage of Total for Expense share?

Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.

Can this formula handle percent of grand total?

Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for percent of grand total. If the logic becomes more complex, generate a custom version with the free tool.

What should I check if the Excel Formula Percentage of Total result is wrong?

Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Expense share fields are formatted consistently.