Microsoft Office Tutorials and References

In Depth Information

**Calculating an Average**

These work in an identical manner to AutoSum itself; that is, you can click in a cell

directly beneath a range of values if you want Excel to automatically use that range, and

then click any of the functions shown in the figure. Let’s look at each one in turn.

Table 4–1 summarizes them.

Table 4–1.
Additional Functions You Can Access Directly by Clicking the AutoSum Button

Name

What It Does

Average

Calculates the average of a range of values;

ignores cells containing text

Count Numbers

Counts
the number of cells in a range

containing values

Max

Calculates the highest value in a range of

values

Min

Calculates the smallest value in range of values

NOTE:
The functions described in Table 4–1 ignore any blank cells they encounter in the

designated range. That means, for example, that

AVERAGE

won’t treat a blank cell as if it were

equal to zero.

Calculating an Average

So, let’s see how to calculate an average, with the blank-cell rule from before in mind.

Now, if you were to click Average, you’d get the

AVERAGE

function in cell H8, and you’d

see what’s shown in Figure 4–12.

Figure 4–12.
Just your AVERAGE Excel function

Press Enter and you’ll see 56.6 in cell H8.