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