Microsoft Office Tutorials and References
In Depth Information
Potential Problems with AutoSum
Figure 10.8.
Figure 10.8. The AutoSum feature is proposing a formula to sum C2:C10.
The AutoSum feature is proposing a formula to sum C2:C10.
Potential Problems with AutoSum
Potential Problems with AutoSum
Although you should always check the range proposed by the AutoSum fea-
ture, in some cases you should be especially wary. If the headings above the
data are numeric, for example, this will fool AutoSum. In Figure 10.9 , the 2012
heading in C1 is numeric. This causes Excel to include the heading incorrectly
in the total for column C.
Search JabSto ::




Custom Search