Microsoft Office Tutorials and References

In Depth Information

**Session 1.2**

Using the AutoSum button

Figure 1-25

AutoSum

button

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