Microsoft Office Tutorials and References

In Depth Information

**Calculating Results Without Entering a Formula**

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.