Microsoft Office Tutorials and References
In Depth Information
MAX and MIN—Recording Highs and Lows
=NAME (range, or ranges)
I’m harping on this point because a great many of the other functions in the Excel repertoire display
a different syntax, as you’ll see.
And while we’re talking about SUM, COUNT, AVERAGE and the like, here’s another handy but
easyto-miss, hidden-in-plain-sight take on these operations and some more. If you select any set of cells
containing numbers (at least two cells, to be exact) and train your gaze on the lower right of the
worksheet screen, on what’s called the Status Bar , you’ll suddenly see a see a mini-report about the data
you’ve highlighted (Figure 3–20):
Figure 3–20. A range’s status report on the Status Bar
There it is—the Average, Count, and Sum of the range you’ve selected. Just know that the Count
here is really COUNTA; that is, it will count any data in the cell—values, text, and even formulas. What
we’re presented with here is an on-the-fly summary of the data in the selected range. None of this
information will actually appear in the worksheet—and once you move elsewhere to other cells, those
figures will change. Still, if you need a quick improvised read on certain data, select that range and take a
And what you see there can be customized, at least within limits. If you right-click anywhere on the
status bar, you’ll trigger a towering short-cut menu, which, among other things, allows you to add three
more calculations to the bar (Figure 3–21):
Search JabSto ::

Custom Search