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.
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.
Step 2:
- Consequently, we will have our total score in the C10Â cell.
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.
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.
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.
Step 3:
- Finally, drag the cursor to the right to get the sum for the rest of the columns.
Similar Readings
- How to Make Cricket Scorecard in Excel (With Easy Steps)
- How to Calculate T Score in Excel (4 Easy Ways)
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.
Step 2:
- As a result, the Create Table dialogue box will appear.
- The dialogue box will show the selected cell range.
- Finally, select OK.
Step 3:
- Consequently, the dataset will turn into a table.
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.
Step 5:
- Then, select the drop-down option button on the right side of the E10Â cell.
- From the drop-down option select SUM.
Step 6:
- As a result, Excel will sum the values of all the cells above.
Step 7:
- Repeat Step 5 for D10 and C10 cells to get the total score of the respective columns.
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.
Step 2:
- After that, in the Visual Basic tab, click on Insert.
- Then, select the Module option.
- Consequently, a coding module will appear.
Step 3:
- In the coding module, write down the following code.
- Then, save the code.
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.
Step 5:
- Consequently, total scores will appear in the desired cells.
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!