In cell C16, I want to calculate the total expenses using the SUM function. I want to find the Individual Category Expenses in % of the Total Expenses. I have a dataset with individual Expense Category and Amount. Example 1: Find Individual Category Expenses in % of Total Expenses We shall use the SUM function to get the Total value first and then we shall divide the Individual value by the Total to get the percentage of total. Using SUM Function and Excel Formula to Calculate Percentage of Total Select cell C6 => Press the keyboard shortcut Ctrl + Shift + 5/ % and you will get the following result.ġ. Second way: Keyboard Shortcut to change the Format of a cell from Decimal to Percentage: Select cell C6 => Home tab => Go to Number group of commands => Click on the Number Format drop-down => You will get the Percentage command. You can format a cell from decimal values to Percentage in these two ways: Step 4: Formatting the cell to show in PercentageĬlick on the Percent Style command and you will get the following result. To do this select the cell C6 => Home tab => Go to Number group of commands => You will get the Percent Style command. Let’s convert the cell value of C6 to percentage. This is why cell C6 is showing value in decimal. Step 3: Formatting the cell to show in PercentageĮxcel automatically shows the results in decimal values. Step 2: Click on the Enter button on your keyboard and you will find the following output. You’ll also get this from the percentage of total. You want to know which product’s sales are high or low. You may have daily or monthly sales data for some products of a store. You can get this quickly by calculating the percentage of total of every transaction category in Excel.

You want to know in which transaction category you are spending the most or vice versa. Suppose, you have a list of your daily or monthly transactions.

You need to calculate the percentage of total in Excel in different scenarios. But all of these methods shown here are applicable to any Excel version. Note: We have used the Microsoft 365 version in this article. In this Excel tutorial, you will learn how to calculate the percentage of total in Excel.Ĭalculating the percentage of total in Excel can be found by getting the Total of some values at first and then dividing the Individual value by the Total value and then formatting the result with Percent Style (%). Get FREE Advanced Excel Exercises with Solutions!

Easy way to calculate texas