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

Chapter 11. Entering Data and Formulas > Totaling a Column Using the Sum Functi...

Totaling a Column Using the Sum Function

The Sum function is perhaps the most commonly used of the Excel functions that carry out mathematical, statistical, financial, date, time, and other calculations.

To total a column using the Sum function:

1.
Click the destination cel for the formula.

2.
Type an equal sign to start the formula and then type the word sum and a left parenthesis (Shift+9) (Figure 11.28).

Figure 11.28. Type “=sum” followed by a left parenthesis in the destination cell.


3.
Drag down the column of numbers to sum (Figure 11.29).

Figure 11.29. Drag down the column to sum, in this case, from B10 to B15.


4.
Press Enter to complete the formula (Figure 11.30).

Figure 11.30. Press Enter to complete the formula.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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