Excel Basics:
AutoSum

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007/2010/2013  or españolIcon: Change web



The formula used the most is SUM. The AutoSum feature makes it easy to total columns or rows. Excel will guess what cells you want to add based on which cells are empty. A neat trick!


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel Basics  
   
Getting StartedTo subtopics      
    ArrangeTo subtopics  
    AutoFillTo subtopics  
    Icon - FootprintData
    Icon - FootprintFormulas reference table 
    Icon - FootprintAutoSum
    FinishTo subtopics   
    Summary
    Quiz
    ExercisesTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Search
Glossary
Appendix


Icon Step-by-Step 

Step-by-Step: AutoSum

 Icon Step-by-Step

What you will learn:

to use AutoSum to add a column
to write a SUM formula yourself
to format numbers as currency with button

Start with: Class disk trips6.xls (saved in previous lesson)

Data Entry

  1. Complete the table at the bottom of the sheet by filling in the values for # of people and Total as shown here.

     # of people   Total
    9                 17000
    23               36000
    18               27000
    18               36000
    12               24000
    20               51000
    12               42000
    12               36000

     

  2. Class disk  Save As  trips7.xls .


AutoSum: Upper Table TotalsAutoSum for # of people

  1. Select cell A25 and type  Totals: 
     
  2. Select cell C25 and click AutoSum button the AutoSum button. Excel guesses you want to add values in range C5:C24 and surrounds that range with a blinking dashed border. The formula looks like  =SUM(C5:C24) 

    The range includes a blank cell, which Excel understands and will ignore.
     

  3. Press ENTER to accept Excel's formula.
     
  4. Select cell E25 and click the AutoSum button.
     
  5. Press ENTER to accept the formula  =SUM(E5:E24) 

Sum Formula: Lower Table Totals

  1. Select cell A37 and type  Totals: 
     
  2. Select cell C37 and type  =sum(c28:c36)  Notice that you did not have to use upper case letters but you must use the = and the parentheses ( ).
     
  3. Press ENTER to accept your formula. This method works when Excel is confused about what to add.
     
  4. Select cell D37 and type   =sum( 
     
  5. Drag from cell D28 to cell D36. Excel enters the range in the formula.
     
  6. Totals for lower table created with AutoSumPress ENTER to accept the formula  =sum(D28:D36)   

    You do not have to type the final parenthesis.

    (Check: are the totals in the lower table the same as in the upper table? They should be.)


Format Numbers

Now that you  have your totals for rows and for the Totals columns, it would be nice to have them look like money! The toolbar button will apply the currency from the Regional Settings in the Windows Control Panel. [Start | Settings| Control Panel | Regional Settings] or [Start | Control Panel | Regional and Language Options]

  1. Formatting selection as currencyHold the CTRL key down and select the following: range E5:E23 , cell E25, range D28:D35; cell D37.
     
  2. Click Button: Currency the Currency button.
     
  3. Click Button: Decrease Decimals the Decrease Decimals button twice to remove unneeded zeros.
     
  4. Class disk Save [trips7.xls]
    full floppy diskHow to handle a full disk

LessonsWorking with Numbers Previous Page Next Page




Teachers: Request permission to use this site with your class

Copyright © 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?


~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~


Last updated: 02 May 2012