• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Constructing Excel Formulas > Using AutoSum to Total Columns and Ro...

Using AutoSum to Total Columns and Rows of Data

Because the most common worksheet calculation is the totaling of data in a list or table, Microsoft created the AutoSum toolbar button. AutoSum writes a formula that uses the SUM function to sum the values in all the cells referenced in the formula, and it writes the formula rapidly. (You'll learn more about functions in Chapter 11.)

AutoSum attempts to guess which cells you want to use in your SUM formula. But if it guesses wrong, you can change the referenced range quickly while you enter the formula.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint