Microsoft Office Tutorials and References
In Depth Information
Using the AutoSum button
syntax for function
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
totals calculated using AutoSum