Part II: Working with Formulas and Functions
288
Counting cells based on multiple criteria ................................................................
In many cases, your counting formula will need to count cells only if two or more criteria are met.
These criteria can be based on the cells that are being counted or based on a range of correspond-
ing cells.Figure 13.2 shows a simple worksheet that I use for the examples in this section. This sheet shows
sales data categorized by Month, SalesRep, and Type. The worksheet contains named ranges that
correspond to the labels in row 1.On the CD
This workbook is available on the companion CD-ROM. The file is named multiple criteria counting
.xlsx.Note
Several of the examples in this section use the COUNTIFS function, which was introduced in Excel 2007. I also
present alternative versions of the formulas, which should be used if you plan to share your workbook with
others who use an earlier version of Excel. n
FIGURE 13.2
This worksheet demonstrates various counting techniques that use multiple criteria.