# How to Total a Column in Excel (7 Effective Methods)

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.

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

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts 