Skip to main content

Calculation of Total Marks, Percentage, Division, Remarks, Maximum & Minimum Number of Students in MS Excel

In this post, I will help you to learn how to calculate total marks, percentage, division, maximum number, minimum number and remarks of students of a class very fast. At first you need to look over the above image very carefully. The above image shows the marks obtained by six students of a class.

Formula to calculate Total Marks of all students within seconds 

First you need to find out the Total Mark of a single student who is on the top of the list i.e, Mani. To calculate Total Mark of Mani, click on the Total Mark cell address of Mani i.e, H6 and then type the formula =sum(1st subject's cell address i.e, b6:last subject's cell address i.e, g6) and then press Enter on the keyboard or click anywhere on the worksheet. Here b6 and g6 are cell address of 1st subject (English) and last subject (Biology) of that student. Read also : How to Enable HTTPS for Blogger Blog.

After getting results, click on the resultant cell address of Total Mark of the 1st student i.e., Mani and place your mouse pointer bottom of the right side corner of that resultant cell. When you hover mouse pointer, it becomes + signs. Now keep press left mouse button and drag to the cell address of the last student (Salman) i.e., h11. Once you release mouse pointer, Total Marks obtained by rest of the students will be displayed. Read also: How to protect your computer from WannaCry ransomware.

Formula to calculate Percentage (%) of all students within seconds

First you need to find out the percentage of a single student who is on the top of the list i.e, Mani. To calculate percentage of Mani, click on the percentage cell address of the first student i.e, I6 and then type the formula =Total Mark obtained by 1st student i.e., h6/number of subjects i.e, 6 and press Enter on the keyboard or click anywhere on the worksheet. Read also How to setup AdSense Page Level Ads.

After getting results, click on the resultant cell address of percentage of 1st student i.e., Mani and place mouse pointer bottom of the right side corner of the resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student (Salman) i.e., I11 . Once you leave mouse pointer percentage of rest of the students will be displayed.

Formula to calculate Division of all students within seconds

First you need to find out the Division of a single student (1st student) who is on the top of the list i.e, Mani. To calculate Division of the 1st student i.e., Mani, click on the Division cell address against 1st student i.e, Mani (cell address J6) and then type the formula =If(I6>=80, “Distinction”, If(I6>=60, “1st Division”, if (I6>=40, “2nd Division”, if(I6>=30, “3rd Division”, “Fail”)))) and press Enter on the keyboard or click anywhere on the worksheet. Read also : How to change UC browser default download path.

After getting results, click on the resultant cell address of Division of 1st student i.e., Mani and place mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the last student's cell address i.e., J11. Once you leave mouse pointer Division of rest of the students will be displayed.

Formula to calculate Maximum number obtained in a subject 

First you need to find out the Maximum number obtained in a subject of a single (1st student) student who is on the top of the list i.e, Mani. To calculate the Maximum number obtained by the 1st student in a subject, click on the Maximum number cell address against 1st student i.e., Mani (K6) and then type the formula =max(1st subject's cell address i.e., for Mani it is b6:last subject's cell address i.e., for Mani it is g6 for Mani) and then press Enter on the keyboard or click anywhere on the worksheet. Read also : How to make money online from home.

After getting results, click on the resultant cell address of Maximum number obtained in a subject by 1st student i.e., Mani and then place the mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student i.e., Salman K11. Once you release the mouse pointer Maximum number will be displayed obtained by the rest of the students. Read also How to record your computer screen in Windows.

Formula to calculate Minimum number obtained in a subject 

First you need to find out the Minimum number obtained by the 1st student i.e, Mani in a subject. To calculate Minimum number obtained by the 1st student i.e., Mani in a subject, click on the Minimum number cell address against 1st student i.e, for Mani L6 and then type the formula =min(1st subject's cell address i.e., for Mani it is b6:last subject's cell address i.e., for Mani it is g6) and then press Enter on the keyboard or click anywhere on the worksheet. Read also : How to Make Your Blog Push Notification Ready.

After getting results, click on the resultant cell address of Minimum number obtained by the 1st student in a subject and then place mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student i.e., for Salman it is L11. Once you leave mouse pointer Minimum number will be displayed obtained by the rest of the students. Read also : How to create AdSense Search Engine and Make Money from it.

Formula to calculate Remarks (Pass or Fail) of students 

First you need to find out the remarks of a single student who is on the top of the list i.e, Mani. To calculate remarks of 1st student i.e., Mani, click on the remarks cell address against the 1st student i.e, for Mani it is M6 and then type the formula =if(cell address of 1st student's percentage  i.e., for Mani it is I6>=30, "Pass", "Fail") and then press Enter on the keyboard or click anywhere on the worksheet. Read also : How to track lost/stolen android phone and secure data.

After getting results, click on the resultant cell address of remarks of 1st student and hover mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student i.e., for Salman it is M11. Once you release mouse pointer remarks of rest of the students will be displayed.

Thanks for reading this post. Feel free to share your views in comment box and appreciate me by this post on social networks.


Comments