Microsoft Office Tutorials and References
In Depth Information
Calculating Results Without Entering a Formula
Calculating Results Without
Entering a Formula
Sometimes, you don’t want to add
another formula into an already complicated
worksheet. No, sometimes, all you want to do is
to perform a quick sum to check some values,
or to find the maximum sales amount in a given
range. Turns out you can quickly calculate the
average and sum of a selected range. You can
also count the number of cells in that range
with something in them. Just select any range,
and instantly, Excel calculates the AVERAGE,
COUNT, and SUM, and displays these results on
the Status bar, as shown in Figure 3-10.
Halfway down the menu, you’ll see a selection
of display options: Average (equivalent to the
AVERAGE function, which computes the average
of the selected range), Count (equivalent to the
COUNTA function, which counts the cells with
some kind of data—non-blank), Numerical Count
(equivalent to the COUNT function which counts
the cells with numbers), Minimum (equivalent
to the MINIMUM function, which finds the
minimum value in a range), Maximum (equivalent to
the MAXIMUM function, which finds the
maximum value in a range), and Sum (equivalent to
the SUM function, which totals the values in a
range). Select the functions you want to display
(these functions appear with a checkmark in
front of them on the menu).
You are not limited to displaying only the Average,
Sum, and Count on the Status bar; you can display
additional (or different) automatic results on the
Status bar as you see fit. Right-click the Status
bar to display a menu, as shown in Figure 3-11.
Excel displays the AVERAGE, SUM,
and COUNT of the selected range
Figure 3-11
Select the functions you want to display
on the Status bar.
Figure 3-10
Excel can perform some calculations
for you automatically.
Search JabSto ::

Custom Search