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.


Download Practice Workbook


4 Easy Ways to Calculate Total Score in Excel

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

Read More: How to Create a Scoring System in Excel (With Easy Steps)


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


Similar Readings


3. Utilizing Total Row Command

In this case, we will opt for the Total Row command to calculate the total score. For utilizing 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

Read More: How to Create Scorecard in Excel (with Detailed Steps)


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


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. To learn more about Excel, you can visit our website, ExcelDemy. Happy Learning!


Related Articles

Adnan Masruf

Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo