Calculate a percent distribution you can use a formula that simply divides an amount by the total. To find a percent of a number use this variant of the formula. - which gives the result 125.
For example 10 of 100 is 01 100 10.
And when you do youll find that Excel can handle them just as well as whole numbers or decimals. The goal here is for us to transform numbers from a decimal format ie. How to add or SUM a column of percentages using an Excel formula so that the total comes to 100. To format the Percent of Grand Total column click the second Sales fields Percent of Grand Total drop down and choose Value Field Settings.