Microsoft Office Tutorials and References
In Depth Information
Counting cells based on multiple criteria
TABLE 17.2 (continued)
=COUNTIF(Data,3)+COUNTIF
(Data,-3)
Returns the number of cells containing the value 3 or –3
=COUNTIF(Data,TRUE)
Returns the number of cells containing the logical value
TRUE
=COUNTIF(Data,TRUE)+
COUNTIF(Data,FALSE)
Returns the number of cells containing a logical value ( TRUE
or FALSE )
=COUNTIF(Data,"#N/A")
Returns the number of cells containing the #N/A error value
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 on a range of
corresponding cells.
Figure 17.2 shows a simple worksheet used for the examples in this section. This sheet
shows sales data categorized by Month, Sales Rep, and Type. The worksheet contains four
named ranges that correspond to the labels in row 1.
FIGURE 17.2
This worksheet demonstrates various counting techniques that use multiple criteria.
Search JabSto ::




Custom Search