Microsoft Office Tutorials and References

In Depth Information

**Basic Counting Formulas**

17

Basic Counting Formulas

The basic counting formulas presented in this section are all straightforward and relatively

simple. They demonstrate the capability of the Excel counting functions to count the

number of cells in a range that meet speciﬁ c criteria.

Figure 17.1 shows a worksheet that uses formulas (in column E) to summarize the contents

of range A1:B10 — a 20-cell range named Data. This range contains a variety of

information, including values, text, logical values, errors, and empty cells.

FIGURE 17.1

Formulas in column E display various counts of the data in A1:B10.