# How to Calculate Total Row and Column in Excel: 4 Methods

### 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 AutoFill sign pops up. Dag the AutoFill 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.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF