# How to Add the Sum of a Column in Excel (7 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for the future. Moreover, one interesting thing is that we need to add up all the cells in a column. Here, all the ways to add up a column in Excel will be discussed. So, you will be able to apply multiple methods for adding up columns in excel in all conditions. In this article, I will show you 7 easy ways of how to add the sum of a column in Excel. Hence, read through the article to learn more and save time.

Table of Contents

## Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.

## 7 Suitable Ways to Add the Sum of a Column in Excel

In this tutorial, I will show you how to add the sum of a column in Excel. Here, I have used 7 different methods to make you understand the scenario properly. For the purpose of demonstration, I have used the following sample dataset. Here, the dataset includes the Names of the Salesman and their monthly Sales.

### 1. Utilize Status Bar to Add the Sum of a Column

Fortunately, it is the simplest way to get the sum of a column. All you need to do is select the column you want to add up. Additionally, you will get the sum in the bottom right corner of your Excel window. However, one of the disadvantages of this method is you wonâ€™t be able to copy the value.

ðŸ“Œ Steps:

• First of all, select the column where you want the sum.
• However, it will automatically show the sum in the Status Bar.

### 2. Add the Sum of a Column Using AutoSum

Moreover, you can use AutoSum to add the sum of a column in Excel. But, the disadvantage of this method is, if there is any empty cell in the column, you will only get the sum of the cells after the last empty cell in that column. So, if your dataset has at least one empty cell in the column you want to sum up, do not use this method. Now, follow the steps below.

ðŸ“Œ Steps:

• At first, select cell C12.

• Now, press ALT + = key and press Enter.

### 3. Input Excel SUM Function

Fortunately, using the SUM function to add up a column in Excel is the most convenient way. Moreover, you can apply the sum function to all types of datasets and you can use the SUM function in multiple ways. For example, I have taken 2 different scenarios to illustrate the use of this function.

#### 3.1 Sum of a Whole Column

Usually, you can use the function to get the sum of the whole column of your dataset. Hence, go through the following steps.

ðŸ“Œ Steps:

• In the beginning, select cell C5 and write down the following formula.

`=SUM(C5:C10)`

However, you can also use the formula below to get the same result.

`=SUM(C5,C6,C7,C8,C9,C10)`

• In the end, hit the Enter key to get your desired output.

#### 3.2 Sum of Selected Cells in a Column

If you want to sum up some selected cells in that column instead of the total column, you have to manually select the cells you want to sum up. Moreover, the process is similar to before. However, we will find the sum of sales for 3 salesmen. Hence, follow the steps.

ðŸ“Œ Steps:

• First, select cell C12 and insert the following formula.

`=SUM(C5,C7,C10)`

• Last, press Enter button to get the total sales of 3 salesmen.

### 4. Insert Table in Excel to Find Column Total

Furthermore, you can add the sum through a Table in a column in Excel. However, the process is simple and easy. So, follow the steps mentioned below.

ðŸ“Œ Steps:

• Initially, select the dataset and go to the InsertÂ tab.
• Then, click on Table.

• Next, check My table has headers box and press OK.

• After that, go to Table Design and check Total Row.

• Finally, you will get the sum just below the table.

Similar Readings

### 5. Apply AGGREGATE Function to Get the Sum of a Column

In addition, to get the sum of a column using the AGGREGATE function you have to type the formula in an empty cell. However, it is used on different functions like AVERAGE, COUNT, MAX, MIN, SUM, PRODUCT, etc. Hence, go through the steps below in order to complete the operation.

ðŸ“Œ Steps:

• First of all, click on cell C12 and write down the formula below.

`=AGGREGATE(9,4,C5:C10)`

• After all, hit the Enter key to get the result.

### 6. Add the Sum with SUBTOTAL Function in Excel

In general, the SUBTOTAL function returns a list or database and itâ€™s in Math/Trig function category. Moreover, it offers 11 Excel functions to perform by inserting the corresponding argument. Hence, read through the steps below.

ðŸ“Œ Steps:

• Firstly, select cell C12 and write down the following formula.

`=SUBTOTAL(9,C5:C10)`

• Lastly, press Enter to get the total sales.

### 7. Find Sum Through AutoFill Feature

Last but not least, you can use the Auto Fill feature to add the sum of a column when you already have the sum of another similar column. For the purpose of demonstration, I have added an extra column of Sales for another month to our present dataset. Hence, read through the steps below.

ðŸ“Œ Steps:

• Initially, find the sum of Sales 1 column.
• Afterwards, use the AutoFill tool to the next row.

• Lastly, the output will appear in the image below.

## How to Add the Sum of a Column in Excel Based on Criteria

When a criterion is given, to make the same you have to use the SUMIF function. Usually, it adds the cells specified by a given condition or criteria. For example, you need to sum up Sales over \$11000. For doing this, you have to use the function. So, follow the steps mentioned below in order to complete the task properly.

ðŸ“Œ Steps:

• In the beginning, click on cell C12 and insert the following formula.

`=SUMIF(C5:C10,">11000",C5:C10)`

• In the end, hit the Enter key to get the output according to your criteria.

## Conclusion

These are all the steps you can follow to add the sum of a column in Excel. Overall, in terms of working with time, we need this for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

For more information like this, visit Exceldemy.com.

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF