Souptik Roy
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.
Download Practice Workbook
Download the practice workbook to practice yourself.
4 Suitable Methods to Autosum Column in Excel
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.
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.
Read More: How to Use AutoSum In Excel (4 Easy Ways)
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.
- Consequently, you will find the formula written in the C11
- As a result, you will find the output just like the picture given below.
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.
- At last, you will find the summation of the column.
Read More: [Fixed!] Excel AutoSum Not Working (4 Possible Solutions)
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
- Click on the Total Row.
- As a result, you will find the total of the column in the C11.
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.
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. You will find such interesting blogs on our website Exceldemy.com. 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.
