Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.
How-To Geek on MSN
Master Excel's Total Row for better data insights
Excel's Total Row uses smart SUBTOTAL logic to ignore hidden data, adapt to filters, flag text errors, and measure performance volatility.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results