We store a huge amount of data in the Column of Excel sheets and most of the time we need to Total the Column. This article will show you the exact methods of it and help you to Total a Column in Excel quickly and accurately.

## How to Total a Column in Excel: 7 Effective Methods

### 1. Excel SUM Function to Total a Column

The **SUM **function in Excel is very useful in finding the Total of a Column. Here, we’ll use **the SUM function** in our very first method.

To help you understand better, I’m going to use a sample dataset as an example. The following dataset represents the Order ID, Item, and Cost of the items in 3 Columns.

#### 1.1 Sum Entire Column

We can use the Excel** SUM **function in a variety of operations. To find the Total of the Entire Column, follow the steps below.

**STEPS:**

- First of all, select cell
**D10**. - There, type the formula:

`=SUM(D5:D9)`

- Then, press
**Enter**. - After pressing
**Enter**, you’ll get the correct result as shown in the following picture.

#### 1.2 Add Non-Continuous Cells in a Column

The Excel** SUM **function can also be used to add Non-Continuous cell values in a Column. This is quite handy to sum up our desired cells only.

**STEPS:**

- At first, select cell
**D10**. - Now type the formula:

`=SUM(D5,D7)`

**NOTE: **Inside the bracket of the **SUM **function, you can input any cell you want to add.

- Then, press
**Enter**. - Finally, you’ll get your desired result.

#### 1.3 Total a Column Using Named Range

We can also apply the Excel** SUM **function to Total a Column using the Named Range. Follow the process below to know how to use it.

**STEPS:**

- First, select the Range of Cells in a Column you want to add.

- Next, go to the
**Define Name**feature under the**Formulas**tab. - Select the feature.

- A dialogue box will pop out.
- There, type any name you want to give in the
**Name**box. - For this example, type
**Cost**. - And then, press
**OK**.

- After that, select cell
**D10**. - There, type the formula:

`=SUM(Cost)`

- Now press
**Enter**. - After pressing
**Enter**, the precise result will appear in cell**D10**.

**Read More:** **How to Sum Entire Column in Excel **

### 2. Total a Column with Excel AutoSum Feature

In Excel, we can Sum the values of the cells very quickly using the **AutoSum **feature. You’ll find the tool **AutoSum **in the **Formulas **tab just like it’s shown in the following image. This method will use the AutoSum feature to find the Total of a Column.

**STEPS:**

- First, select cell
**D10**. - Next, press the
**AutoSum**tool.

- After that, press
**Enter**. - After pressing, you’ll get your expected result in cell
**D10**.

### 3. Keyboard Shortcut to Sum a Column in Excel

Another effective and fast process to Total a Column in Excel is to use the **Keyboard Shortcut **keys ‘**Alt**’ and ‘**=**’ together. You have to press and hold down the ‘**Alt**’ key which is marked as **1 **in the image below. While holding it down you have to press the ‘**=**’ key, marked as 2 in the image and it’ll simply do the Sum.

**STEPS:**

- First of all, select cell
**D10**. - There, press down ‘
**Alt**’ and ‘**=**’ together.

- After that, press
**Enter.**This will return the**S**u**m**of the entire column.

### 4. Excel Table Feature to Total a Column

The Excel Table feature is really helpful while finding the Total of a Column. In this method, we are going to **use the Table feature** in Excel to get the Total.

**STEPS:**

- First of all, select the Range of Cells you want to work with.

- Then, select the
**Table**feature under the**Insert**tab.

- A dialogue box will pop out.
- There, check the ‘
**My table has headers**’ note. - Next press
**OK**.

- After pressing
**OK**, you’ll get the**Table**like it’s shown in the image below.

- After that, select any cell of the
**Table**. - Now, go to the ‘
**Table Style Options**’, which you’ll get in the**Table Design**tab. - There, check the
**Total Row**option.

- In the end, the Total of the Column will simply appear in the cell just under the Column.

**Read More:** **How to Sum Columns in Excel Table **

### 5. Sum a Column Based on a Criteria

The **SUMIF **function in Excel is very effective when adding up cell values following criteria. Here, we’ll use **the SUMIF function** to add only the values that are greater than 1000.

Let me show you the step-by-step process.

**STEPS:**

- In the beginning, select cell
**D10**. - There, type the formula:

`=SUMIF(D5:D10,“>1000”)`

- After that, press
**Enter**. - Finally, you’ll get the sum of the values that are greater than 1000.

### 6. Excel SUBTOTAL Function to Total a Column

Another Excel function to operate multiple operations is **SUBTOTAL**. In this method, we’ll use** the SUBTOTAL function** to find the Total of a **Column**.

**STEPS:**

- Firstly, select cell
**D10**. - There, type the formula:

`=SUBTOTAL(`

- Right after that, you’ll see a bunch of functions in a list.

- Finally, type the rest of the formula:

`=SUBTOTAL(9,D5:D9)`

- And then, press
**Enter**. - After pressing, you’ll get the Total of the Column.

**Read More:** **How to Sum Columns in Excel When Filtered **

### 7. Total of a Column in Excel Status Bar

Our last method is the quickest and easiest one in Excel to find the Total of a Column. This method is convenient for getting the Total, taking the Numbers only into consideration from the entire column.

**STEPS:**

- First of all, select the Entire Column or the Range of Cells you want to add up.

- After selecting, just look at the Excel Status Bar, which you’ll find at the bottom right corner of your Excel Worksheet.
- The status bar will show you the Sum of your selected column or the range of cells.

**Read More:** **How to Sum Every Nth Column in Excel **

**Download Practice Workbook**

Download the provided workbook to practice by yourself.

## Conclusion

Now you will be able to Total a Column in Excel using the above-described methods. Keep practicing them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

## Related Articles

**How to Sum Columns by Color in Excel****How to Calculate Total Row and Column in Excel****How to Sum Multiple Rows and Columns in Excel**

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