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.

## Download Practice Workbook

Download the provided workbook to practice by yourself.

## 7 Effective Methods to Total a Column in Excel

### 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 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:**

- Firstly, 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 (9 Easy Ways)**

### 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**.

**Read More:** **How to Calculate Total Row and Column in Excel (4 Methods)**

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

Another effective and fast process to **Total **a **Column **in **Excel **is to use **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**Sum**of the entire column.

**Read More:** **How to Add Up Columns in Excel (12 Methods)**

### 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 (7 Methods)**

### 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**.

**Read More:** **Sum Multiple Columns Based on Multiple Criteria in Excel**

### 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 Ways)**

### 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 (3 Methods)**

## 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.