# 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.
`=SUM(C5:F5)`

• 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.
`=G5/\$D\$11`

• 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.

### 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.
`=SUM(C5:F5)`

• 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.
`=SUM(G5)/SUM(\$G\$5:\$G\$9)`

## 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.

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF