1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 AutoSUM
Adding Numbers in Excel

By , About.com Guide

Excel 2007 AutoSUM Function

Excel 2007 AutoSUM Function

© Ted French

The AutoSum feature is a shortcut to using Excel's SUM function. It provides a quick way to add up columns or rows of numbers in a spreadsheet.

The syntax for AutoSum is the same as the SUM function.

=SUM( Number1, Number2, ... Number255 )

Up to 255 numbers can be entered into the function.

Example Using Excel's AutoSum Feature:

Note: For help with this example, see the image to the right.

  1. Enter the following data into cells C1 to C6:
    11, 12, 13, 14, 15, 16
  2. Make sure that cell C7 - the location where the results will be displayed is blank.

  3. Drag select cells C1 to C6 in the spreadsheet.

  4. Click on the Home tab.

  5. Click on the AutoSum button on the ribbon to enter the SUM function into cell C7.

  6. Press the ENTER key on the keyboard to accept the function.

  7. The answer 81 should appear in cell C7.

  8. Click on cell C7 and the complete function = SUM (C1 : C6) appears in the formula bar above the worksheet.


Related Articles
More Spreadsheets Quick Tips
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Math Functions
  6. AutoSum - AutoSum Function - Excel AutoSum Function

©2009 About.com, a part of The New York Times Company.

All rights reserved.