How to Autosum Column in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

When working in Excel, you need to do many kinds of operations. One of the most common operations is to make a sum of a column or a row. Calculating the sum of a column becomes easier than all other operations by obtaining the AutoSum procedure. In this article, I will show how to Autosum Column in Excel with 4 easy methods. I will describe the methods with the necessary steps and illustrations. I hope these methods will increase your Excel skills.


How to Autosum Column in Excel: 4 Suitable Methods

Let’s consider a dataset of the Sales report of S.R. Production. The dataset has 2 columns B & C called Month & Amount of the company. This dataset ranges from B4 to C10 with this dataset, I will show the procedure to calculate Autosum Column in Excel. Let’s jump into the methods without any further delay.

Dataset of Autosum Column in Excel


1. Autosum Column in Excel by Using Status Bar

In this method, I will Autosum Column in Excel by using Status Bar with one click. This is the easiest process to know the sum of a column. Follow the steps given below.

Steps:

  • Consider the dataset mentioned earlier.
  • A portion is indicated with an arrow in the next picture. Click on that part.
  • Consequently, you will get the summation as well as the count and average of the whole column.

Autosum Column in Excel by Using Status Bar

Read More: How to Use AutoSum In Excel 


2. Apply AUTOSUM Function to Sum a Column

In this part, I will apply AUTOSUM Function to sum a column. This is another easy process. Follow the steps given below to Autosum Column in Excel.

Steps:

  • First Select the C11
  • After that, Go to the Home tab of your Toolbar.
  • Then Select the Editing
  • You will find the AutoSum option there. Click on it.

AUTOSUM Function to Autosum Column in Excel

  • Consequently, you will find the formula written in the C11

AUTOSUM Function to Autosum Column in Excel

  • As a result, you will find the output just like the picture given below.

AUTOSUM Function to Autosum Column in Excel


3. Use a Shortcut Key to Autosum Column in Excel

Here, I will show the use of a shortcut key to calculate Autosum Column in Excel. This process is not so popular but can shorten your time. Let’s follow the procedure step by step.

Steps:

  • First, Select the C11.
  • Then, Click the  Alt+= 
  • Consequently, you will find the formula written in the C11.
  • Hence, Press Enter.

Use a Shortcut Key to Autosum Column in Excel

  • At last, you will find the summation of the column.

Use a Shortcut Key to Autosum Column in Excel

Read More: [Fixed!] Excel AutoSum Not Working


4. Apply Total Row Option in Table to Autosum Column

This is another process to calculate AutoSum Column in Excel. In this process, you need to convert your dataset into a table. The steps you should follow are given below.

Steps:

  • First, Click on any cell of the table.
  • Then Go to the Table Design tab in your Toolbar.
  • After that, Select the Table Style Operation
  • Here, you will find the Total Row

Apply Total Row Option in Table to Autosum Column in Excel

  • Click on the Total Row.
  • As a result, you will find the total of the column in the C11.

Apply Total Row Option in Table to Autosum Column in Excel


Sum Specific Cells in Excel

Now, I will show the process to calculate the summation of cells in Excel. This operation is basic. Follow the steps given below and make a summation of cells.

Steps:

  • First Select the C11
  • Then Write down the following formula in the C11
=SUM(C5,C6,C7,C8,C9,C10)
  • After that, Press the Enter

  • Consequently, you will find the summation of the column.


Sum Multiple Columns in Excel

Here, I will show the procedure of calculating the summation of multiple columns in Excel. I added a new column in our dataset called New Amount. Follow the steps mentioned below.

Steps:

  • Select the C11 cell first.
  • Write down the following formula in the C11
=SUM(C5:C10,D5:D10)
  • Then Press the Enter

  • At last, you will find the result given below.


Things to Remember

  • You should bear in mind that you can calculate the Average, Count Numbers, Maximum and Minimum values of the column under the AutoSum option.

Download Practice Workbook

Download the practice workbook to practice yourself.


Conclusion

In this article, I have tried to explain how to Autosum Column in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles


<< Go Back to Autosum in ExcelSum in Excel | Calculate in Excel | Learn Excel

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.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo