Microsoft Office Tutorials and References
In Depth Information
The basic counting formulas presented here are all straightforward and relatively simple. They demonstrate how
to count the number of cells in a range that meet specific criteria. Figure 7-1 shows a worksheet that uses for-
mulas (in column E) to summarize the contents of range A1:B10 — a 20-cell range named Data.
Figure 7-1: Formulas provide various counts of the data in A1:B10.
You can access the basic counting.xlsx workbook shown in Figure 7-1 at this book's
About this chapter’s examples
Most of the examples in this chapter use named ranges for function arguments. When you adapt these formulas
for your own use, you'll need to substitute either the actual range address or a range name defined in your work-
Also, some examples are array formulas. An array formula, as explained in Chapter 14, is a special type of for-
mula. You can spot an array formula because it is enclosed in brackets when it is displayed in the Formula bar.