Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

SUM and AutoSUM Step by Step Tutorial

By Ted French, About.com

2 of 5

Using the SUM Function

Using the SUM function in Excel

Using the SUM function in Excel

© Ted French

Using the SUM Function

Note: refer to the image at the top of the page for help on these steps.

  1. Select cell B13.
  2. Type " = sum( " in the cell.
  3. Use the mouse point to drag select cells B9 to B12.
  4. Type the closing round bracket " ) " to complete the function.
  5. Press the ENTER key on the keyboard.

Note: It is not necessary to type in function names in upper case. Excel will convert them to capitals for you.

Explore Spreadsheets

About.com Special Features

Build Your Own Website

Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >

Connect Your Home Computers

Easy ways to connect two computers for networking purposes. More >

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Excel 2003 Functions
  6. Excel SUM - Excel Auto SUM Function - Free Excel Tutorials

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

All rights reserved.