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.


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.

Excel SUM Function to Total a Column


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)

Excel SUM Function to Total a Column

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

Excel SUM Function to Total a Column


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.

Excel SUM Function to Total a Column

STEPS:

  • At first, select cell D10.
  • Now type the formula:
=SUM(D5,D7)

Excel SUM Function to Total a Column

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.

Excel SUM Function to Total a Column


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.

Excel SUM Function to Total a Column

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

Total a Column with Excel AutoSum Feature

STEPS:

  • First, select cell D10.
  • Next, press the AutoSum tool.

Total a Column with Excel AutoSum Feature

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

Keyboard Shortcut to Sum a Column in Excel

STEPS:

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

Keyboard Shortcut to Sum a Column in Excel

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

Excel Table Feature to Total a Column

  • Then, select the Table feature under the Insert tab.

Excel Table Feature to Total a Column

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

Excel Table Feature to Total a Column

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

Sum a Column Based on a Criteria

STEPS:

  • In the beginning, select cell D10.
  • There, type the formula:
=SUMIF(D5:D10,“>1000”)

Sum a Column Based on a Criteria

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

Excel SUBTOTAL Function to Total a Column

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

Total of a Column in Excel Status Bar

STEPS:

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

Total of a Column in Excel Status Bar

  • 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: Sum Every nth Column in Excel(Formula and VBA Code)


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

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

Leave a reply

ExcelDemy
Logo