Microsoft Office Tutorials and References

In Depth Information

**Special Tricks with AutoSum**

Figure 10.10.

Figure 10.10.
Excel can choose between summing two numbers above or four

Excel can choose between summing two numbers above or four

numbers to the left. Excel chooses incorrectly.

numbers to the left. Excel chooses incorrectly.

Special Tricks with AutoSum

Special Tricks with AutoSum

There is an amazing trick you can use with AutoSum. If you select a range

of cells before clicking the AutoSum button, Excel does a much better job of

predicting what to sum.

In
Figure 10.10
, for example, you could select B11:E11 before clicking the

AutoSum button, and Excel would know to sum each column. Be careful,

though, because Excel does not preview its guess before entering the formula.

You should always check a formula after using AutoSum to make sure the

correct range was selected.

If your selection contains a mix of blank cells and nonblank cells, Excel

adds the AutoSum to only the blank cells. In
Figure 10.11
,
for example, you

select the range B2:F11 before clicking the AutoSum button.