ID EN
…
#Dynamic array

PERCENTOF

Excel Functions

Return a subset of data as a percentage of all data

Syntax

EXCEL 
=PERCENTOF(data_subset, all_data)

Arguments

Parameter Description
data_subset A subset of data as a range or array.
all_data All data as a range or array.

Return Value

A decimal value that represents the percentage

Details

The PERCENTOF function is designed to return a subset of data as a percentage of a larger data set. The output from PERCENTOF is a decimal number that can be formatted with Excel's percentage number format. Essentially, PERCENTOF performs a calculation like this: The result will be a decimal number that must be formatted as a percentage. For example, if the subset of data is 250 and the full set of data is 1000, PERCENTOF will return 0.25: When 0.25 is formatted as a percentage, it will display as 25% on the worksheet. In the worksheet shown above, the formula in cell D5 looks like this: The result is 37% (0.37) since $950 is 37% of the sum of the range C5:C12, which is $2570. As the formula is copied down, it returns each value in column C5:C12 as a percentage of $2570.

Examples

Example 1

The PERCENTOF function is designed to return a subset of data as a percentage of a larger data set. The output from PERCENTOF is a decimal number that

EXCEL 
=SUM(data_subset)/SUM(data_all)
Example 2

The result will be a decimal number that must be formatted as a percentage. For example, if the subset of data is 250 and the full set of data is 1000

EXCEL 
=PERCENTOF(250,1000) // returns 0.25
Worksheet Example

In the worksheet shown above, the formula in cell D5 looks like this:

EXCEL 
=PERCENTOF(C5,$C$5:$C$12)

See Also

GROUPBY PIVOTBY