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

While constructing a mark sheet in Excel, you may need to calculate the percentage of the marks. In this article, you’ll learn how to calculate the percentage of marks in Excel with appropriate illustrations.


Download Practice Workbook

You can download the practice workbook from the link below.


5 Ways to Calculate Percentage of Marks in Excel

As with Excel, there are multiple ways of computing percentages with functions and Excel tools. So, without further delay, let’s dive in!

Now, consider the Marks Distribution dataset shown in the B4:F11 cells. Here, we have the Names of the students and their scores in Physics, Chemistry, Biology, and Math out of a Total Mark of 100 in each subject.

Dataset 1

Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.


Method-1: Using Arithmetic Formula to Calculate Percentage of Marks

Let’s start with the simplest and most obvious way of calculating the percentage of marks in Excel. Simply put, let’s use the Arithmetic Formula.

📌 Steps:

  • At the very beginning, go to the G5 cell and insert the expression below.

=C5+D5+E5+F5

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

Using Arithmetic Formula

How to Calculate Percentage of Marks in Excel Using Arithmetic Formula

  • Then, compute the percentage of marks using the formula given below.

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

How to Calculate Percentage of Marks in Excel Using Arithmetic Formula

  • Finally, press CTRL + SHIFT + % on your keyboard to change the number format to percentage. Thus, your result should look like the image given below.

How to Calculate Percentage of Marks in Excel Using Arithmetic Formula


Method-2: Calculating Percentage of Marks with SUM Function

Another convenient way to compute percentages involves using the SUM function. So, let’s see it in action.

📌 Steps:

  • First of all, go to the G5 cell and insert the expression below.

=SUM(C5:F5)

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

Using SUM Function

  • Next, move to the H5 cell and type in the formula below.

=G5/$D$13

How to Calculate Percentage of Marks in Excel Using SUM Function

Eventually, your output should look like the picture shown below.

How to Calculate Percentage of Marks in Excel Using SUM Function


Method-3: Utilizing AutoSum Feature to Calculate Percentage of Marks

If using formulas doesn’t suit you, then our next method is for you. Here, we’ll utilize Excel’s AutoSum feature to calculate the summation of the marks. Now, allow me to demonstrate the process in the steps below.

📌 Steps:

  • Firstly, select the C5:F5 range of cells >> in the Editing section, and click the AutoSum button.

Using AutoSum Feature

Eventually, the result should look like the screenshot shown below.

How to Calculate Percentage of Marks in Excel Using AutoSum Feature

  • Secondly, navigate to the H5 cell and insert the expression below.

=G5/$D$13

How to Calculate Percentage of Marks in Excel Using AutoSum Feature

Subsequently, your output should look like the image shown below.

How to Calculate Percentage of Marks in Excel Using AutoSum Feature


Method-4: Applying the SUBTOTAL Function to Calculate Percentage of Marks

If you’re one of those people who enjoy using Excel formulas, then the following method has you covered. In this method, we’ll apply the SUBTOTAL function to calculate the summation of the marks. It’s simple and easy. Just follow these steps.

📌 Steps:

  • First and foremost, go to the G5 cell and type in the expression below.

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

Using SUBTOTAL Function

  • Secondly, go to the H5 cell and enter the expression below.

=G5/$D$13

How to Calculate Percentage of Marks in Excel Using SUBTOTAL Function

Consequently, your table should appear as in the screenshot given below.

How to Calculate Percentage of Marks in Excel Using SUBTOTAL Function


Method-5: Employing the SUMIF Function to Calculate Percentage of Marks

Sometimes, you may need to calculate the percentage of marks for a specific student from a given dataset. In such a situation, we’ll utilize the SUMIF function to compute the percentage of marks in Excel. So let’s begin.

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

Dataset 2

📌 Steps:

  • Firstly, go to the G5 cell and type in the expression below.

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

Here, 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. Here, C5:C14 is the range argument that refers to the Name column. Then, G4 represents the criteria argument to apply within the given range. Lastly, 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%

How to Calculate Percentage of Marks in Excel Using SUMIF Function

Subsequently, your output should look like the picture shown below.

How to Calculate Percentage of Marks in Excel Using SUMIF Function


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section


Conclusion

I hope this article helps you understand how to calculate the percentage of marks in Excel. If you have any queries, please leave a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo