AutoSum

The AutoSum button allows you to quickly sum a range of cells or access other common commands such as average, count, max and min.

  1. Position your cursor where you want the formula/answer to be inserted.


  2. Display the Home ribbon and click on the button or press Alt+=.
  3. To display other commands, click on the drop list button to the right of the AutoSum button to display the following command choices:

  4. A dotted line appears around the range of cells that Excel thinks you want to add up.  If this is not correct, select the cells you wish to include.


  5. Press Enter.

Also note that you can access the full range of commands by selecting More Functions in step 2. Refer to the Using Formula Functions article for more information.

Additional References