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.
