As soon as you do this, it will give you the auto-sum in the cell below the selection. You can also use the Auto-sum by selecting the column that has the value and hitting the auto-sum option in the formula tab. The above steps would instantly give you the sum of the entire column in the selected cell. In the Function Library group, click on the Autosum option.Select the cell right below the last cell in the column for which you want the sum.Suppose you have the dataset as shown below and you want to get the sum of the values in column B.Д«elow are the steps to get the sum of the column:

Get the SUM of a Column with AutoSum (with a Single-click/Shortcut)ДЄutosum is a really awesome tool that allows you to quickly get the sum of an entire column with a single click. To do this, right-click on the status bar and make the customizations. If you want, you can customize the status bar and get more data such as the maximum or the minimum value from the selection. One negative of using the status bar to get the sum is that you can not copy this value. In case you donвЂ™t want to select the entire column, you can make a range selection, and the status bar will show the sum of the selected cells only. In case you want to get the sum of multiple columns, you can make the selection, and it will show you the total sum value of all the selected columns. In our example, cell B1 has the text title, which is ignored and the sum of the column is displayed in the status bar. The good thing about using the status bar to get the sum of the column is that it ignores the cells that have the text and only considers the numbers. This is a really quick and easy way to get the sum of an entire column. To do this, select the entire Column B (you can do that by clicking on the B alphabet at the top of the column).ДЄs soon as you select the entire column, you will notice that the status bar shows you the SUM of the column. Suppose you have a dataset as shown below and you want to quickly know the sum of the sales for the given weeks. Select and Get the SUM of the Column in Status BarД®xcel has a status bar (at the bottom right of the Excel screen) which displays some useful statistics about the selected data, such as Average, Count, and SUM.

Get the Sum of Column Based on a Criteria.Convert Tabular Data to Excel Table to Get the Sum of Column.Using the SUM Function to Manually calculate the Sum.Get the SUM of a Column with AutoSum (with a Single-click/Shortcut).Select and Get the SUM of the Column in Status Bar.

How to add columns in excel