How to Calculate Total Score in Excel (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Users of Excel frequently need to calculate the sum of various scores. This allows them to compare the performances of the different individuals. In this article, we will discuss 4 easy methods to calculate total score in Excel.


How to Calculate Total Score in Excel: 4 Easy Ways

In this discussion, we will learn 4 handy methods to calculate total score in Excel. Firstly, we will use the SUM function to calculate the score. Secondly, we will opt for the AUTOSUM command to do our job. Then, we will choose the Total Row option for the table to complete our task. Finally, we will resort to a VBA code to calculate the total score in Excel. We will use the following sample dataset to illustrate the methods.

Sample Data


1. Using SUM Function

In this method, we will use the SUM function to calculate the total score in Excel. The SUM function adds individual values, cell references, ranges of values, or a mix of all three. Here, we will insert a range of cells into the SUM function to get the total score. Follow the steps below to calculate the total score.

Step 1:

  • Firstly, select the cell where you want to have the total score.
  • In our case, the cell is C10.
  • Then, write down the following formula,
=SUM(C5:C9)
  • Here, we will sum the subject scores in the cell range (C5:C9) to get the total score.
  • Finally, hit Enter.

(4) Easy Ways to Calculate Total Score in Excel

Step 2:

  • Consequently, we will have our total score in the C10 cell.

(4) Easy Ways to Calculate Total Score in Excel

Step 3:

  • Finally, move the cursor to the right to get the total score for the rest of the two columns in cells D10 and E10.

(4) Easy Ways to Calculate Total Score in Excel


2. Applying AUTOSUM Command

In this instance, we will opt for the AutoSum command to calculate the total score in Excel. The AutoSum command is nothing but the SUM function. The only difference is, in the AutoSum command, the SUM function takes its argument automatically whereas, in the solo application, the users have to set the argument.  Follow the ensuing steps to do so.

Step 1:

  • Firstly, select the cell where you want to sum the scores to get the total score.
  • In this instance, the selected cell is C10.
  • Then, go to the Home tab.
  • From there, navigate to the Editing group.
  • Finally, click on the AutoSum command.

(4) Easy Ways to Calculate Total Score in Excel

Step 2:

  • As a result, the SUM function will show up in the C10 cell along with the range of cells whose values it will sum.
  • In this case, the range is (C5:C9).
  • Finally, hit Enter.

(4) Easy Ways to Calculate Total Score in Excel

Step 3:

  • Finally, drag the cursor to the right to get the sum for the rest of the columns.

(4) Easy Ways to Calculate Total Score in Excel


3. Utilizing Total Row Command

In this case, we will opt for the Total Row command to calculate the total score. To utilize this command, firstly, we will turn the dataset into a table. This will allow us to access the Total Row command. Follow the subsequent steps to accomplish the task.

Step 1:

  • Firstly, select the entire dataset.
  • Here, we will select the cells in the range (C4:E9).
  • Secondly, go to the Insert tab.
  • From the Insert tab, select the Table command.

(4) Easy Ways to Calculate Total Score in Excel

Step 2:

  • As a result, the Create Table dialogue box will appear.
  • The dialogue box will show the selected cell range.
  • Finally, select OK.

(4) Easy Ways to Calculate Total Score in Excel

Step 3:

  • Consequently, the dataset will turn into a table.

(4) Easy Ways to Calculate Total Score in Excel

Step 4:

  • After that, select any of the cells from the table.
  • Then, go to the Table Design tab.
  • After that, select Table Style Options.
  • Finally, check the box beside Total Row.
  • As a result, the dataset’s final row will be followed by a row with the label Total.

(4) Easy Ways to Calculate Total Score in Excel

Step 5:

  • Then, select the drop-down option button on the right side of the E10 cell.
  • From the drop-down option select SUM.

(4) Easy Ways to Calculate Total Score in Excel

Step 6:

  • As a result, Excel will sum the values of all the cells above.

(4) Easy Ways to Calculate Total Score in Excel

Step 7:

  • Repeat Step 5 for D10 and C10 cells to get the total score of the respective columns.

Sample Data


4. Using VBA Code

In this method, we will resort to a VBA code to do the job. The VBA in this article is very simple. This uses the SUM function of worksheet object to get the total score. Adhere to the steps below to calculate the total score in excel using VBA code.

Step 1:

  • To begin with, go to the Developer tab.
  • From there, hover down to the Code group and select the Visual Basic tab.
  • Consequently, a Visual Basic dialogue box will appear.

Sample Data

Step 2:

  • After that, in the Visual Basic tab, click on Insert.
  • Then, select the Module option.
  • Consequently, a coding module will appear.

Sample Data

Step 3:

  • In the coding module, write down the following code.
  • Then, save the code.

Sample Data

Sub total_score()
Range("C10") = Application.WorksheetFunction.Sum(Range("C1:C9"))
Range("D10") = Application.WorksheetFunction.Sum(Range("D1:D9"))
Range("E10") = Application.WorksheetFunction.Sum(Range("E1:E9"))
End Sub

Step 4:

  • Finally, go to the Run tab and click on it.
  • From the drop-down option, select the Run command to run the code.

Sample Data

Step 5:

  • Consequently, total scores will appear in the desired cells.

Sample Data


Download Practice Workbook


Conclusion

This article deals with different methods to get the total score from different scores. After going through this article, the readers will have a thorough understanding of how to calculate total score in Excel. This will allow them to compare their performances based on total scores.  Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality.


<< Go Back to Scoring | Formula List | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Adnan Masruf
Adnan Masruf

Adnan Masruf, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. His deep passion for research and innovation seamlessly aligns with his dedication to Excel. In this capacity, Masruf not only skillfully addresses challenging issues but also exhibits enthusiasm and expertise in gracefully navigating intricate situations, underscoring his steadfast commitment to consistently delivering exceptional content. His interests... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo