Microsoft Office Tutorials and References

In Depth Information

**Using AutoSum**

Figure 10.7.

Figure 10.7.
The AutoSum drop-down offers the capability to average and

The AutoSum drop-down offers the capability to average and

more.

more.

When you click the AutoSum button, Excel seeks to add up the numbers that

are above or to the left of the current cell. In general, when you click the

AutoSum icon, Excel guesses which cells you are trying to sum. Excel auto-

matically types the SUM() formula. You should review Excel
’
s guess to

make sure that Excel chose the correct range to sum. In
Figure 10.8
,
for ex-

ample, Excel correctly guesses that you want to sum the column of quantit-

ies above the cell.