How to calculate percentage of total in excel
![](https://www.thetechedvocate.org/wp-content/uploads/2023/10/maxresdefault-2023-10-12T002602.801-660x400.jpg)
Calculating percentage of total in Excel is a commonly required task, whether you are a student, an employee or just someone who loves to work with numbers. Excel offers a variety of formulas and functions to help you perform various calculations easily. In this article, we will guide you on how to calculate the percentage of the total in Excel using different methods.
Method 1: Using Simple Formula
Step 1: Enter your data in Excel.
First, open Microsoft Excel and enter your data set into the cells. Make sure to arrange your data in a manner that makes it easy for you to calculate the percentages.
Step 2: Create a formula for the total.
Next, add up all the numerical values from your data set by using the SUM() function. To do this, simply choose an empty cell and type =SUM(A1:A5) (assuming your data is in cells A1-A5) and hit Enter. The sum of your data will appear in the cell.
Step 3: Calculate the percentage for each value.
For each value in your data set, divide it by the total obtained from Step 2 and multiply by 100 to get the percentage. Simply input the formula =(cell_value/total)*100 into an adjacent cell and hit Enter. In our example, if the value is in A1 and the total is in B6, our formula would be =(A1/B6)*100.
Step 4: Copy the formula for all values.
Once you’ve calculated one percentage, simply copy and paste (or drag) the formula into adjacent cells for your other values’ percentages.
Method 2: Using Excel Formatting
Step 1: Enter your data in Excel.
Similar to method 1, start by entering your data set into Excel cells.
Step 2: Create a formula for total.
Find out the total of all numerical values using the SUM() function described in method 1.
Step 3: Calculate the ratio for each value.
Divide each value in your data set by the total calculated from step 2. Input the formula =(cell_value/total) into an adjacent cell. In our example, if your value is in A1 and total in B6, your formula would be =(A1/B6).
Step 4: Format the cells as percentages.
Finally, format these calculated ratios as percentages. To do this, first select the cells with ratios, then go to the “Home” tab on the Excel Ribbon. In the “Number” group, select “Percentage” from the dropdown list to format cells as percentages. Excel will automatically multiply by 100 and add a ‘%’ symbol.
Now you have successfully calculated the percentage of total for your data set using two different methods in Excel. Choose whichever method works best for you and continue mastering other Excel functions for a seamless experience with spreadsheets.