Chapter 16: Using Formulas for Statistical Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . .
10
The COUNT function will count only numeric values in a given range. It requires only a
single argument where you pass a range of cells. For example, this formula will count only
those cells in range C4:C8 that contain a numeric value:
=COUNT(C4:C8)The COUNTA function will count any cell that is not blank. This function can be used when
counting cells that contain any combination of numbers and text. It requires only a single
argument where you pass a range of cells. For instance, this formula will count all of the
nonblank cells in range C4:F4:
=COUNTA(C4:F4)The COUNTBLANK function will count only the blank cells in a given range. It requires only
a single argument where you pass a range of cells. For instance, this formula will count all
of the blank cells in range C4:F4:
=COUNTBLANK(C4:F4)Using Excel’s Conversion Functions
You may work at a company where it’s important to know how many cubic yards can be cov-
ered by a gallon of material or how many cups are needed to fill an Imperial gallon.
You can use Excel’s CONVERT function to produce a conversion table containing every pos-
sible type of conversion you need for a set of measures. Figure 10.13 illustrates a conversion
table created using nothing but Excel’s CONVERT function.
FIGURE 10.13
Creating a unit-of-measure conversion table