Microsoft Office Tutorials and References
In Depth Information
Making Range Values COUNT
8
(blank cell)
12
And once again, if your data are arrayed conventionally in one column or row, you can click on
Average in the AutoSum drop down menu, press Enter, and AVERAGE will be posted in the cell you’ve
selected (Figure 3–16):
Figure 3–16. Selecting AVERAGE
You can incorporate multiple ranges in AVERAGE as well. (Your decimal point questions will be
taken up in the next chapter).
Making Range Values COUNT
And what about the third entry in the AutoSum drop-down menu, Count Numbers ? Here Excel’s
menu description doesn’t quite match the actual name of the function it generates — COUNT —and for a
reason, which we’ll explain right after we let you know what COUNT actually does. (Figure 3–17):
Figure 3–17. Counting numbers—only
 
Search JabSto ::




Custom Search