Microsoft Excel offers multiple ways to sum the values of a specific column. You can use the status bar, AutoSum, and the SUM function to add up the values in your column. Here’s how to use them.
RELATED: How to Add Numbers in Microsoft Excel
Ways to Sum a Column’s Values in Excel
One way to sum a column is to use Excel’s status bar. If you only want to see the sum and you don’t want to display it anywhere in your spreadsheet, use this method.
The second method is to use AutoSum, an Excel feature that automatically adds the SUM function with its required arguments to your selected cell.
Lastly, you can use the popular SUM function to sum an entire column or specific rows or ranges in it.
View Your Column’s Sum in Excel’s Status Bar
To only view the sum of your column, then first, launch your spreadsheet with Microsoft Excel.
In your spreadsheet, select the cells in your column for which you want to see the sum. To select your entire column, then at the top of your column, click…
Read Full Article Source
