# How to Calculate Percentage of Marks in Excel (5 Simple Ways)

## 5 Ways to Calculate Percentage of Marks in Excel

Our sample dataset contains student Names their scores in Physics, Chemistry, Biology, and Math.

### Method 1 – Using Arithmetic Formula to Calculate Percentage of Marks

Steps:

• Enter the following formula in G5.

`=C5+D5+E5+F5`

C5, D5, E5, and F5 indicate the marks obtained by Zoe in Physics, Chemistry, Biology, and Math, respectively.

• Enter the following formula in H5.

`=G5/\$D\$13`

In this formula, the G5 cell refers to the Marks Scored while the D13 cell points to the Total Mark of 400.

Note: Please make sure to use Absolute Cell Reference by pressing the F4 key on your keyboard.

• Press CTRL + SHIFT + % on your keyboard to change the number format to percentage. Your result will look like the image below.

### Method 2 – Calculating Percentage of Marks with SUM Function

Steps:

• Enter the following formula in G5.

`=SUM(C5:F5)`

C5:F5 range of cells points to the marks obtained by Zoe in the 4 subjects respectively.

• Enter the following formula in H5.

`=G5/\$D\$13`

Your output will be displayed as shown in the following image.

### Method 3 – Utilizing AutoSum Feature to Calculate Percentage of Marks

Steps:

• Select the C5:F5 range of cells >> in the Editing section, click the AutoSum

The result will be as shown below.

• Enter the following formula in the cell H5.

`=G5/\$D\$13`

The percentage will be displayed as shown in the image below.

### Method 4 – Applying the SUBTOTAL Function to Calculate Percentage of Marks

Steps:

• Enter the following formula in G5

`=SUBTOTAL(109,C5:F5)`

In the above formula, 109 (function_num argument) refers to the SUM function and the C5:F5 (ref1 argument) range of cells indicates the marks scored by Zoe in the 4 subjects.

• Enter the following formula in H5.

`=G5/\$D\$13`

You will get the following subtotal.

### Method 5 – Employing the SUMIF Function to Calculate Percentage of Marks

To calculate the percentage of marks for a specific student from a given dataset, we can use the SUMIF function.

Let’s consider the Marks Distribution of French dataset in the B4:D14 cells. In this dataset, we have the student Names and their scores in French for two semesters.

Steps:

• Enter the following formula in the G5

`=SUMIF(C5:C14,G4,D5:D14)/\$D\$16`

The C5:C14 and the D5:D14 range of cells refer to the Name and the French columns respectively. In contrast, the G4 and the D16 cells point to the Name Michell and the Total Mark of 200.

Note: Please make sure to use Absolute Cell Reference by pressing the F4 key on your keyboard.

⚡ Formula Breakdown:

• =SUMIF(C5:C14,G4,D5:D14) → adds the cells specified by a given criteria or condition. C5:C14 is the range argument that refers to the Name G4 represents the criteria argument to apply within the given range. D5:D14 is the optional sum_range argument which indicates the values to sum within the range.
• Output → 152
• =SUMIF(C5:C14,G4,D5:D14)/\$D\$16 → becomes
• =152/\$D\$16 → In this expression, the value 152 is divided by the D16 cell which is the Total Mark of 200.
• 152/200 → 76%

Your output should look like the image shown below.

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!