The Excel PERCENTOF function returns what fraction one set of numbers is of a larger set — it divides the sum of a subset by the sum of a total, giving a ready-made share or percentage.
Syntax
| Argument | Description | |
|---|---|---|
data_subset | Required | The range or values whose share you want (the numerator). Its sum is divided by the total. |
data_all | Required | The full range or values that make up the whole (the denominator). |
How to use it
PERCENTOF is shorthand for SUM(subset)/SUM(all). It returns a decimal share that you format as a percentage.
If the first three rows total 350 and the whole column B2:B10 totals 1000, PERCENTOF returns 0.35 — format the cell as a percentage to display 35%. It is the tidy way to answer “what portion of the total does this group represent?” without writing two SUMs.
New in Excel 2024. PERCENTOF was added in Excel 2024 and Microsoft 365. On older versions write it the long way: =SUM(B2:B4)/SUM(B2:B10).
Try it: interactive demo
Pick a PERCENTOF example to see the formula and its result.
Practice workbook
Frequently asked questions
What does PERCENTOF actually calculate?
SUM(data_subset)/SUM(data_all). The result is a decimal share — format it as a percentage to read it as, say, 35%.How is PERCENTOF different from writing two SUMs?
=PERCENTOF(sub, all) is shorter and clearer than =SUM(sub)/SUM(all), but both give the same number.Does the result come out as a percentage automatically?
Which Excel versions have PERCENTOF?
=SUM(subset)/SUM(all) instead.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class