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.

**Table of Contents**Expand

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

**command to do our job. Then, we will choose**

*AUTOSUM**th*

*e*

*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

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

**SUM****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
cell.*C10*

**Step 3:**

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

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

*function. The only difference is, in the*

**SUM***command, the*

**AutoSum***function takes its argument automatically whereas, in the solo application, the users have to set the argument. Follow the ensuing steps to do so.*

**SUM****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
tab.*Home* - From there, navigate to the
group.*Editing* - Finally, click on the
command.*AutoSum*

**Step 2:**

- As a result, the
function will show up in the*SUM*cell along with the range of cells whose values it will sum.*C10* - 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.

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

*command. Follow the subsequent steps to accomplish the task.*

**Total Row****Step 1:**

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

**Step 2:**

- As a result, the
dialogue box will appear.*Create Table* - 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
tab.*Table Design* - 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
cell.*E10* - 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**forand*D10*cells to get the total score of the respective columns.*C10*

### 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*of worksheet object to get the total score. Adhere to the steps below to calculate the total score in excel using

**SUM**function**VBA**code.

**Step 1:**

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

**Step 2:**

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

**Step 3:**

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

```
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
tab and click on it.*Run* - From the drop-down option, select the
command to run the code.*Run*

**Step 5:**

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

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