What is the syntax for PERCENTOF in Excel?

The syntax for PERCENTOF is: =PERCENTOF(data_subset, data_all)

How do I use the PERCENTOF function?

To use PERCENTOF, type =PERCENTOF( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does PERCENTOF work with?

PERCENTOF works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is PERCENTOF not working in my Excel?

Common issues with PERCENTOF include #DIV/0! if total is zero. Start by checking the syntax =PERCENTOF(data_subset, data_all), then verify each referenced cell or range.

Statistical

PERCENTOF Function in Excel

Calculates the percentage that a subset represents of a total.

Syntax

=PERCENTOF(data_subset, data_all)

Arguments

data_subset (required): The subset values
data_all (required): The total values

Examples

=PERCENTOF(FILTER(B:B, A:A="North"), B:B) - North region as % of total - Result: 0.35 (35%)
=PERCENTOF(C2:C10, C2:C100) - Subset percentage - Result: Percentage value

PERCENTOF for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

#DIV/0! if total is zero

Use cases

Market share analysis
Budget allocation
Performance metrics

Frequently asked questions

What is the PERCENTOF function in Excel? PERCENTOF calculates the percentage that a subset represents of a total. The syntax is =PERCENTOF(data_subset, data_all). Typical use cases include market share analysis, budget allocation, performance metrics.
How do I use the PERCENTOF function? To use PERCENTOF, type =PERCENTOF( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does PERCENTOF work with? PERCENTOF works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is PERCENTOF not working in my Excel? Common issues with PERCENTOF include #DIV/0! if total is zero. Start by checking the syntax =PERCENTOF(data_subset, data_all), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.