Enter an equal sign and open parenthesis and select the. To calculate percent of a total ie. Now you can calculate each items percentage of total.
Type this formula F2F11 F2 is the total of the first item F11 is the total number of all items drag fill handle down to fill the formula to cells.
Now you can calculate each items percentage of total. Percentage of Days spent in USA 5 15 100 3333 Percentage of Days spent in Home Town 10 15 100 6666. How to find the percentage of a total. Calculating percentages 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.