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 (version 2409)
* This function is logically equivalent to =SUM(data_subset)/SUM(data_all)
* If you use the Insert Function dialog box this function appears in the Text category.
* You can use the GROUPBY function to return the summary table after grouping and aggregating by row.
* You can use the PIVOTBY function to return the summary table after grouping and aggregating by row and column.
* You can use the SUM function to return the total of the numerical values.
* For the Microsoft documentation refer to support.microsoft.com

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

1 - What percentage of 10 is 1.
2 - What percentage of 10 is 5.
3 - What percentage is the number 5 from the total 30 (5 + 10 + 15)
4 - What percentage is the number 10 from the total 30 (5 + 10 + 15)
5 - What percentage is the number 15 from the total 30 (5 + 10 + 15)