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

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

*AUTOSUM***option for the table to complete our task. Finally, we will resort to a**

*the Total Row***to calculate the total score in**

*VBA code***. We will use the following sample dataset to illustrate the methods.**

*Excel*### 1. Using SUM Function

In this method, we will use** the SUM function** to calculate the total score in Excel.

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

**the SUM function****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**.*

**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 only difference is, in the*

**the SUM****function***command,*

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

**the SUM function****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,
will show up in the*the SUM function*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.

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

*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,
will sum the values of all the cells above.*Excel*

**Step 7:**

- Repeat
**Step 5**forand*D10*cells to get the total score of the respective columns.*C10*

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

*of worksheet object to get the total score. Adhere to the steps below to calculate the total score in excel using*

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

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

**, you can visit our website,**

*Excel***ExcelDemy**. Happy Learning!