How to Calculate Percentage for Multiple Rows in Excel

We will use the following sample data set. We have the marks of four subjects for the final exam of five random people.

Method 1 – Use the AutoFill Feature to Calculate Percentage for Multiple Rows

Steps:

• To calculate the total marks of Nathan, use the following SUM function formula in cell G5.

• Press Enter to see the result and drag the formula to the lower cells using the Fill Handle.

• To calculate the percentage of marks for Nathan, insert the following formula in cell H5.

• After pressing Enter you will get the decimal value from the above formula.

• To convert it into percent, select cell H5 and go to the Home tab of the ribbon.
• From the Number group, select the Percent Style (%) icon to format the selected cell as a percent.
• You will find the value of cell H5 in the percent format.

• Bring the cursor of the mouse to the bottom-right corner of cell H5 and you will see the AutoFill sign.
• Drag the sign to the cells below to apply the same formula and the cell format to those cells.

Here’s the result.

Read More: How to Apply Percentage Formula for Multiple Cells in Excel

Method 2 – Utilize the Quick Analysis Tool to Calculate a Percentage Between Multiple Rows

We want to compare the marks among the examinees without using the total marks.

Steps:

• Use the following SUM function formula in cell G5 to calculate the total marks of Nathan.

• Press Enter and drag the formula to the lower cells using AutoFill.

• Select the cell range G5:H5.
• Click on the Quick Analysis Tool that appears below the selected cell range after selecting them.

• From the analysis tool, click on the Totals tab after the previous step.
• From the options, select % Total.

• You will find the percentages of the respective person besides their acquired marks after following the previous instruction.

• Double-click on cell H5, and you will find the formula used by Quick Analysis Tool to calculate percentages in this regard.

Read More: How to Calculate Percentage of Filled Cells in Excel

Things to Remember

• While calculating the percentage in the first method, use an absolute cell reference for the total, or you will not get the desired value.
• There are two % Total options in the Quick Analysis Tool. Select the second one, which will calculate the percentage for rows.

Download the Practice Workbook

Related Articles

• Calculate Percentage Using Absolute Cell Reference in Excel
• Calculate Percentage in Excel VBA
• How to Calculate Percentage above Average in Excel
• How to Apply Percentage Formula in Excel for Marksheet
• IF Percentage Formula in Excel
• How to Find the Percentage of Two Numbers in Excel
• How to Calculate Contribution Percentage with Formula in Excel
• How to Use Food Cost Percentage Formula in Excel
• How to Calculate Variance Percentage in Excel

<<Go Back to Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel