# How to Add Total Row in Excel: Best 2 Methods (2024)

Do you work with large datasets in Excel?

Adding a total row can be a lifesaver for calculating important statistics in your table.

In this article, we’ll explore the two best methods for adding a total row in Excel. These are sure to save you time and boost your productivity 😉

Get ready to streamline your data analysis and impress your colleagues with your Excel skills!

You can also download the sample workbook here to practice adding total rows in real-time.

**Table of Contents**

## Add a total row to a table

Adding a total row to a table is pretty straightforward. And adding it will take you less than 5 seconds.

Suppose we have the following table. It contains information about the monthly sales of different companies.

We want a total row at the bottom showing the net amount acquired in each month 📅

To add a total row at the bottom,

- Select the table.
- Go to the table
**Design**tab under**Table Tools**. - Under the
**Table Style Options**section, mark the**Total Row**checkbox.

- A total row will be inserted at the bottom of your table.

As evident, the middle columns of the table appear empty. We have to insert functions in these cells manually.

To sum up each month, we will apply the SUM formula. You can choose different functions from the drop-down menu.

- Click on the small arrow in column B in the Total row. The drop-down list will appear. Select
**SUM.**

- Excel will apply the function to column B as:

We will do the same with column C:

The SUM function is applied, and Excel shows the total sales made in each month.

It’s that easy. Try it yourself using the sample workbook 😀

## Add a total table row with a shortcut

You can add a total row at the end of your table using this shortcut too.

Say, we have the following table. It contains information about the strength of different school classes each year.

We want to find the average class strength each year. We will add a total row at the bottom of this table to average the values using a keyboard shortcut.

To do that,

- Select the table.
- Press
**CTRL + SHIFT + T** - The Total row appears.

Note that we want to find the average here. But the total row appears with a SUM of column C. The format is also set to Currency here instead of General.

This setting is by default – to change it, simply select the desired function from the drop-down. and change the format from the options.

Upon selecting the Average function from the drop-down menu, Excel shows the result as:

Apply the same function to the remaining cells as:

Pretty cool, no? 🤩

## Add a total row with formulas

Another easy way to add a total row at the bottom of Excel tables is by using Excel formulas.

This might take slightly more time than the methods mentioned above, but it works just fine. Let’s see it below.

Suppose we have the following table. It shows the increase in prices of certain products over the years.

We want to find the average unit price of the products mentioned. We can quickly do that by creating a Total row at the bottom of the table.

To do that,

- Select the row next to the last row of the table.
- Type in
**Total.**

Note that as soon as you press Enter after typing Total, the table adds a border to the total row. The border is extended to the cells in front of the Total row as well.

Also, note that the SUM of column C did not appear automatically, as seen earlier. That’s because we are adding the values manually this time, so we need to apply all the formulas ourselves.

- In column B, add the AVG formula as

**=AVERAGE(B2:B10)**

- Press Enter.

The AVERAGE of the column appears in the last cell.

To copy the formula to the remaining rows, click the Fill Handle and drag it to the other cells.

The formula appears in all cells. You can now format the new table row as you like.

This is yet another easy and quick method to add a total row. It is most useful when you can’t add a total row using the shortcut or Design tab for some reason.

Make sure to give it a try using the sample workbook.

## That’s it – Now what?

In this article, we saw how to add a total row at the end of a table using Table tools. We also saw how to do the same using formulas and some easy shortcuts.

Adding a total row in an Excel table is very easy, and you should be able to master it once you practice it a couple of times.

Apart from these cool shortcuts and tools, Excel has many other awesome features. The best of these is the Functions feature.

You can try practicing some core Excel functions like VLOOKUP, IF and SUMIF, and some others.

You can learn them in my 30-minute free email course only at the cost of your email address. So join now to learn this and much more.

## Other resources

Did you enjoy reading this article? If yes, then we’re sure you’d love to read more.

Try similar topics: Delete Blank Rows, Insert Multiple Rows, Unhide Rows in Excel, and more.