1-866-245-5224 sales@keystonelearning.com

Excel 2003: AutoSum

Excel 2003: AutoSum

AutoSum is probably the most common Excel function. It’s used to automatically total a group of cells either in a column or a row. The beauty of the AutoSum button is that it automatically detects the closest range of cells for adding. And, if it guesses wrong, it’s a snap to fix.

Calculate a Range Using AutoSum

     
  1. Select the cell where the total should appear
     
  2.  
  3. Click the AutoSum command on the Standard toolbar
     
  4.  
  5. Verify the formula is correct
     
  6.  
  7. Press [Enter]
     

Calculate a Range Manually

     
  1. Select the cell where the total should appear
     
  2.  
  3. Type =SUM(
     
  4.  
  5. Using your mouse, highlight the range of numbers that you are totaling
     
  6.  
  7. Press [Enter]