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.
Search JabSto ::




Custom Search