How to use AutoSum function? Select a cell next to the numbers you want to sum, click AutoSum on the Home tab in the Editing group, and select Sum from the menu.

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.

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.

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.