**Method 1 – Use the SUM Function to Calculate Total Row and Column in Excel**

**1.1 Calculate Total Row**

**Steps:**

- Learn how to calculate row values from our dataset. Select a new cell. Select cell
**F5**and write down the**SUM**function in that cell. The**SUM**function is,

`=SUM(C5:E5)`

- Press
**Enter**on your keyboard and you will be able to get $163,347.00 as the output of the**SUM**function.

- Place your cursor on the bottom right side of cell
**F5**and an**A****utoFill**sign pops up. Dag the**A****utoFill**signÂ downward.

- After completing the above process, you will be able to get the output of the
**SUM**function along with the rows shown in the screenshot below.

**1.2 Calculate Total Column**

**Steps:**

- Select cell
**C14,**and type the**Â SUM**function to calculate the total sales in the first quarter in column C. The**SUM**function is,

`=SUM(C5:C13)`

- After typing the
**SUM**functionÂ in the**Formula Bar**, press**Enter**on your keyboard, and you will be able to get $492,162.00 as the return of the**Â SUM**function.

- AutoFill the
**SUM**function in columns**D**, and**E**and you will get your desired output, which has been given in the below screenshot.

**1.3Â Non-contiguous Row and Column**

**Steps:**

- Select cell
**E15**.

- Write down the
**SUM**function in that cell.

`=SUM(E5,E8,E13)`

- Where
**E5**is the sales of Tom,**E8**is the sales of Ema, and**E13**is the sales of John in the 3rd quarter.

- Press Enter, and you will get your desired output as given in the screenshot below.

**Method 2- nsert the AutoSum Formula to Calculate Total Row and Column in Excel**

**Step 1:**

- Sum up cell values automatically by applying the
**AutoSum**formula, first, select cells**C5**to**E13**.

- From your
**Home**Ribbon, go to

**Home â†’ Editing â†’ AutoSum**

- Press on the
**AutoSum**menu, and you will get the return of the**AutoSum**formula that has been given in the screenshot below.

**Step 2:**

- Select rows
**5**to**14**from our dataset.

- From your
**Home**Ribbon, go to

**Home â†’ Editing â†’ AutoSum**

- Sum up, the total rows by using the
**AutoSum**option.

**Method 3 Apply the ROWS and COLUMNS Formula to Calculate Total Row and Column in Excel**

**Steps:**

- Select cell
**H6,**and type the**COLUMNS**function. Type in the**Formula Bar**is,

`=COLUMNS(B4:E13)`

- After selecting cell
**H6,**press**Enter**on your keyboard, and you will get 4 as the return of the**COLUMNS**function.

- Select cell
**H7**and write down the**ROWS**function. Type in the Formula Bar is

`=ROWS(B4:E13)`

- Press
**Enter**on your keyboard and you will get 10 as the output of the**ROWS**function.

**Method 4 – Perform Table Design Option to Calculate Total Row and Column in Excel**

**Steps:**

- Select any convenient cell for our work. Select
**cell C5**Â go to,

**Insert â†’ Tables â†’ Table**

- While clicking on the
**Table**option, a**Creating Table**window will instantly appear in front of you. From that window, press**OK.**

- From the
**Table Design**ribbon, go to,

**Table Design â†’ Table Style Options â†’ Total Row**

- Clicking on the
**Total Row**, you will get the sum of column**E**in cell**E14**.

- Select cell
**C14,**and a**Filter Button**will appear in the bottom right**Â**corner of that cell. Click the Filter Button, and a window will appear. From that window, select the Sum option.

- Get $492,162.00 as the sum of column
**C**in cell**C14**. Calculate the total sum of column**D**in cell**D14**by performing the Table Design Option that has been given in the screenshot below.

**Things to Remember**

You can use **Ctrl + Shift + T** as keyboard shortcuts instead of the **Table Design** option. Another way to apply the** AutoSum** formula is **Alt+=**.

**#NAME** error will happen when the argument is not properly passed.

The error named **#VALUE!** happens when the value is not expected by the** SUM** function.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

## Related Articles

**How to Sum Multiple Rows and Columns in Excel****How to Sum Columns by Color in ExcelÂ****How to Sum Columns in Excel When FilteredÂ****How to Sum Entire Column in Excel**

**<< Go Back to Sum ColumnsÂ | Sum in Excel**** | Calculate in Excel | Learn Excel**