Use the PERCENTOF function to return the percentage that a subset makes up of a given data set. It commonly used in GROUPBY and PIVOTBY functions.
Note: PERCENTOF is logically equivalent to =SUM(data_subset)/SUM(data_all)
Syntax
The PERCENTOF function sums the values in the subset and divides it by all the values.
=PERCENTOF(data_subset,data_all)
|
Argument |
Description |
|---|---|
|
data_subset Required |
The values that in the data subset |
|
data_all Required |
The values that make up the entire set. |
Example
Example 1 uses PERCENTOF to calculate the percentage that Bib-Shorts and Bike Racks comprise of the entire set.
