WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Add Total Row in Excel (3 Easy Methods)

July 22, 2022
11.1K Views

If you want to learn how to add a total row in excel, you should know that you will first need to create a table with the data. A total row in Excel will give you a quick overview of different columns in a table.

Here are primary methods you can use to learn how to add total row in excel.

Introduction

If you are looking for a fast and easy way to quickly add all the data in your Excel spreadsheet? With an Excel total row, you can get totals of any data column (or columns) with just a few clicks. In this comprehensive guide, you'll learn how to add a total row in Excel, whether you have the design tab or not. We'll cover different methods, including using the sum function and adding totals manually.

Additionally, we’ll dive into more advanced topics like formatting custom statistical values and sorting groups according to subtotal numbers. By the end of this guideline, you would better understand how to set up and use total rows in Excel and when they come in handy while manipulating and analyzing data. Let’s get started!

A Total Row in Excel: How to Add it Using Different Methods

A total row in Excel is a powerful tool that can help you automatically add up values in a table's column. This can be especially valuable for people aiming to assess data, base their decisions on data insights, and generate conclusive reports. Within this guide, we will delve into various techniques for incorporating how to add a total row in Excel. These methods encompass utilizing the "Table Design" tab, harnessing Excel's sum function, and employing Google Sheets.

How to add total row in excel using the table design tab?

To learn how to add total row in excel 2016 using the table layout, you will need to perform the following steps:

1. As mentioned above, you must first create a table with your data to insert an entire row. To create the table, select your data and then go to Insert> Table.

2. After that, a Create table box will appear. If you notice that the range matches the range of your dataset and My table has the header is checked, you can click OK.

3. Now, your data will be displayed as a table.

4. Once you have created your table, you can easily add the total row to the table. Then you need to go to the Table Layout tab and check Total Row.

5. To continue the process of how to add total row in excel 2019, you will need to check the total row. You will notice that a new row called Totals has been created at the bottom of your table. You should know that by default, the sum of the last column will be displayed.

6. Now, you can get different types of information from the totals row. For example, if you want to know the unit price per Kg of all the items on your list, you can perform the calculation. You have to select the cell of the total row in the unit prices per Kg column, which will look like a small downward arrow. If you click on the said arrow, you will be able to see the list of calculations that you can perform with the total row.

7. Also, by clicking More Features, you can apply other features. But to know the total unit price, you will need to calculate the Average unit price from the drop down list.

After selecting Average, you can get the average of the Unit Price per Kg column in the total row.

How to Add a Total Row in Excel Using the Sum Function

The SUM function is another easy way to add a total row in Excel. You can use this function to sum up a range of cells, select a range of cells with data you want to sum up, and type "=SUM(the range of cells)" into the cell where you want the total sum to appear. Below are the steps on how to add a total row using the SUM function in Excel:

1. Select the cell where you want the total to display.

Select the cell



2. Type "=SUM(" (without quotes) in the cell.

type sum



3. Select the range of cells that you want to add up.

4. Close the formula with ")" and press "Enter."

choose the formula



5. The results should appear in the cell.

displayed in the cell


How to Add a Total Row in Sheets

How to Add a Total Row in Sheets



Google Sheets is a popular spreadsheet software that is free and has comparable features to Microsoft Excel. If you are using Sheets, you can add a total row by following the steps below:

1. Choose the cell range for which you wish to calculate the sum.

Select the cell



2. Click the function button next to the formula bar with the Sigma symbol.

formula bar with the Sigma symbol



3. From the dropdown menu, select "SUM."

4. The results should appear in the cell.

Results appear in the cell


How to Add Total Row in Excel: Methods and Techniques

Excel provides users with a quick and efficient way to calculate totals for columns within a table. Adding a total row in Excel can give you an overview of the data and make it easier to analyze. There are several methods you can use to add total rows in Excel. This guideline will discuss three primary methods for adding total rows in Excel.

Method 1: Using the SUM Function

The SUM function is a quick and reliable way to add a total row in Excel. This method involves using the SUM function to calculate the totals of your columns and then inserting that total into a new row.

Here's how to add a total row using the SUM function in Excel:

1. Select the cell below the column you want to total.

Select the cell



2. Type the word “Total” in the cell

Type the word



3. Select the cell next to “Total” and enter the SUM formula using the following syntax: =SUM(range).

syntax: =SUM(range)



4. Press Enter.

5. You will now see the total of the column displayed in the cell.

displayed in the cell



6. You can repeat this process for each column in your table.

Method 2: Adding Total Row without Design Tab

If you cannot access the design tab, you can still add a total row to your table using a different method. This approach involves using the AutoSum feature and a few keyboard shortcuts.

Here's how to add a total row without the design tab in Excel:

1. Click on the last cell in the table and hit Tab. It will create a new row at the bottom of the table.

2. Type “Total” in the first cell of the new row.

how to add total row in Excel



3. Click on the cell next to “Total” and hit Alt + =

Click on the cell next to “Total”



4. Press Enter to see the total for that column.

Press Enter



5. Repeat this process for each column in your table.

Method 3: Adding Total Row in Sheets

You can still add a total row to your table using Google Sheets instead of Microsoft Excel. The method is similar to Excel, but there are a few differences.

Here's how to add a total row in Sheets:

1. Click on the last row in your table to create a new row.

Click on the last row



2. Select the cell where you want the total to appear.

select the cell



3. Type =SUM(ABOVE).

Type =SUM(ABOVE)



4. Hit Enter to see the total for that column.

5. You can repeat this process for each column in your table.

Best Alternative WPS Office?

WPS Office may have different brand recognition or longevity than Microsoft Office. Still, it offers many benefits, making it a compelling option for those seeking an alternative to the industry giant.

WPS Office

  • Cost-Effective

One of the most significant advantages of WPS Office is its cost. While Microsoft Office subscriptions can cost upwards of $99 per year, WPS Office offers a free version and a premium version that only costs $29 per year. It is a particularly attractive option for small businesses or individuals needing more money to spend on expensive software subscriptions.

  • Compatibility with Various Formats

WPS Office also supports various file formats, making it a versatile option for users of different data types. It possesses the capability to unlock and modify documents in Microsoft Office formats and PDFs. Furthermore, WPS Office provides integrated file conversion tools, enabling users to transform files into various formats without the requirement for external software.

  • Rich Features

WPS Office offers robust features that can rival those of Microsoft Office. Its word processing application, Writer, boasts powerful formatting tools, a built-in PDF converter, and even a Resume Assistant to help users build professional-looking resumes.

The spreadsheet application, Spreadsheets includes a variety of formulas and functions and supports pivot tables and charts. Finally, the presentation application, Presentation offers templates, various slide formats, and even a multimedia editor. One of the unique features of WPS Office is its integrated PDF editor, which allows users to fill out forms, annotate, and even password-protect their PDFs.

  • User-Friendly Interface

WPS Office's user interface is intuitive and clean, making it easy to navigate and use. Additionally, the software is relatively lightweight, taking up only 200M of computer memory, making it ideal for older or less powerful devices. The customizable interface allows users to arrange tools and features according to their preferences.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

How to Add Total Row in Excel Using WPS Office

If you're looking at how to add a total row to a table in WPS Office Spreadsheets, you're in luck - it's a straightforward process that doesn't require an in-depth knowledge of formulas or functions. To do this, follow these steps:

1. Choose the table for which you intend to include a total row.

2. Click on the "Table" tab in the upper-left corner of the screen and select "Total Row" from the dropdown menu.

select



3. A fresh row will emerge at the table's lowermost part, denoted as the "Total" row. Type in the formula you want to use to calculate the total. For example, if you want to calculate the sum of a column, type "=SUM(A1:A10)" in the first cell of the "Total" row, replacing "A1:A10" with the range of cells you want to sum.

Total row



4. Press the "Enter" key, and the sum will be displayed in the cell.

Select enter, and the sum will be displayed in the cell


FAQs

1. How to Obtain the Row Number of a Cell in Sheets?

To obtain the row number of a cell in Sheets, simply select the cell and look at the very left of the formula bar. You will see the row number displayed. Another method is to use the ROW function, which returns the row number of a specific cell. For example, typing =ROW(A1) will return the row number of cell A1.

2. How do I count Rows Quickly in Sheets?

To swiftly count rows in Sheets, use the COUNTIF formula for any-value rows: =COUNTIF(A1:A10, ""). Employ COUNTBLANK for no-value rows: =COUNTBLANK(A1:A10). COUNTIF with criteria counts specific-value rows, e.g., =COUNTIF(A1:A10, "50").

The Bottom Line

In this comprehensive guide on how to add total rows in Excel, you've gained insight into various methods suitable for all expertise levels. Whether through the "Table Design" tab, SUM function, or Google Sheets, you're equipped to streamline data analysis.

Notably, the advantages of WPS Office shine through its cost-effectiveness, format compatibility, rich features, and user-friendly interface. As you navigate the realm of spreadsheet applications, these techniques and insights will enhance your data summarization endeavors.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.