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

Chapter 7. Using Excel Functions > Creating a Total with the SUM Function

Creating a Total with the SUM Function

The most commonly used function in Excel is the SUM function, which adds two or more values together and displays the total in the current cell. If any of the values change, the SUM total will automatically update. There are a number of different methods to enter the SUM function, but the following section describes two of the most common ways. The syntax for the SUM function is =SUM(range of values to total).

Entering a SUM Function

One way to enter a SUM function is to type the function in its syntax directly into a cell where you want the answer. Like other formulas, Excel will display the answer in the current cell, but display the actual function in the Formula bar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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