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).
0 Comments
Leave a Reply. |