How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

If your business uses an Excel file to track sales information, you can use the SUM formula to add up all order totals. The SUM formula can be applied to a certain number or cells or an indefinite ...

The sum of the column of zeros will be displayed in the cell. Alternatively, you can type in the Sum function -- "=sum()" -- and the range to be summed if you are familiar with the Excel Sum function.

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.