## Download Practice Workbook

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

__Method 1 –__

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

- Copy the formula to the cells below using the
**Fill Handle Tool**.

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

**Read More: ****How to Apply Percentage Formula in Excel for Marksheet (7 Applications)**

__Method 2 –__** Calculating Percentage of Marks with SUM Function**

__Method 2 –__

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

**Read More: ****Calculate Grade Using IF function in Excel (with Easy Steps)**

**Similar Readings**

**Excel Formula for Pass or Fail with Color (5 Suitable Examples)****How to Calculate Letter Grades in Excel (6 Simple Ways)****How to Calculate Average Percentage of Marks in Excel (Top 4 Methods)**

__Method 3 –__** Utilizing AutoSum Feature to Calculate Percentage of Marks**

__Method 3 –__

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

**Read More: ****How to Make a Grade Calculator in Excel (2 Suitable Ways)**

__Method 4 –__** Applying the SUBTOTAL Function to Calculate Percentage of Marks**

__Method 4 –__

** 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 (**argument

*ref1***)**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.

**Read More: ****How to Calculate Grade Percentage in Excel (3 Easy Ways)**

__Method 5 –__** Employing the SUMIF Function to Calculate Percentage of Marks**

__Method 5 –__

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 theargument that refers to the*range**Name***G4**represents theargument to apply within the given range.*criteria***D5:D14**is the optionalargument which indicates the values to sum within the range.*sum_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.

**Read More: ****How to Make Result Sheet in Excel (with Easy Steps)**

## Related Articles

**How to Calculate Subject Wise Pass or Fail with Formula in Excel****Make Automatic Marksheet in Excel (with Easy Steps)****How to Compute Grades in Excel (3 Suitable Ways)****Calculate Grades with Weighted Percentages in Excel**