PERCENTOF function
Summary
Sums the values in the subset and divides it by all the values
Syntax
The PERCENTOF function sums the values in the subset and divides it by all the values.
=PERCENTOF(data_subset,data_all)
data_subset Required | The values that in the data subset
data_all Required | The values that make up the entire set.
data_subset Required | The values that in the data subset
data_all Required | The values that make up the entire set.
Example
=SUM(data_subset)/SUM(data_all)