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

website.

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-

book.

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.

For example: