Use the PERCENTOF Function to Simplify Percentage Calculations in Excel
In other words, the PERCENTOF function tells you the value of subset a as a ... to the overall total you want to calculate. If you've used a formatted table, this will force Excel to add the ...