Aung Shine
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.
