Learn Excel 365 formulas fast! From AutoSum to Intellisense, learn how to work smarter and analyze data with ease. Tips, ...

Microsoft Excel makes it possible for users to sum columns in multiple ways. For example, you can use the AutoSum, the Status Bar, and even the Sum function to calculate values in one or more columns.

Enter a formula or use the AutoSum feature to total all values in a row in Excel. The AutoSum feature enables you to obtain a total for all values in a row or column at the click of a button.

When you click Excel's AutoSum button (the one in the toolbar that looks like Σ) from a cell next to a row or column of numbers, Excel automatically sums those numbers.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.