First click into cell D2 so the percentage shows up in the Percentage column. In the formula bar type sum without quotes and then click the first result the sum formula which adds all numbers in a range of cells. F3-E3E3 The result will appear in the cell.
As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula.
Select the cell where you want to display the percentage. B5-B4B5 Step 2 Excel displays this as a decimal so click the Percent Style button on the Ribbon or use the above mentioned shortcuts to format it as a percent. C6 C11. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of.