PERCENTOF

PERCENTOF(data_subset, data_all)

Returns the percentage of a value compared to the total.

data_subset	The values that in the data subset.
data_all	The values that make up the entire set.

REMARKS

* This function was added in Microsoft 365.
* This function is logically equivalent to =SUM(data_subset)/SUM(data_all)
* You can use the GROUPBY function to return the grouping of your data along one axis and aggregates the associated values.
* You can use the PIVOTBY function to return the grouping of your data along two axis and aggregates the associated values.
* You can use the SUM function to return the total of the numerical values.
* This function was first released in December 2023.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=PERCENTOF(1, 10) = 10.00%
2	=PERCENTOF(5, 10) = 50.00%
3	=PERCENTOF(5, {5, 10, 15}) = 16.67%
4	=PERCENTOF(10, {5, 10, 15}) = 33.33%
5	=PERCENTOF(15, {5, 10, 15}) = 50.00%

1 - What percentage is the number 1 of 10.