Microsoft Office Tutorials and References
In Depth Information
Session 1.2
Using the AutoSum button
Figure 1-25
syntax for function
mode indicator
changes to Point
3 . Press the Tab key to move to cell G10. The result of the formula =SUM(F6:F9) appears in
cell F10, and you are in position to calculate the next set of values.
4 . Click the AutoSum button on the Standard toolbar to enter the SUM function in cell
G10, and then press the Enter key to complete the formula =SUM(G6:G9) , accepting the
range that Excel highlighted. See Figure 1-26. Nine items were sold, for a total of $163.
Calculating the total quantity and total income for the co-op
Figure 1-26
totals calculated using AutoSum
Search JabSto ::

Custom Search