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 specifi 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.
 
Search JabSto ::




Custom Search