Microsoft Office Tutorials and References
In Depth Information
Counting Cells That Meet Multiple Criteria
Figure 116-1 shows a worksheet that I use for some of the examples that follow. This sheet shows
sales amount categorized by Month, SalesRep, and Type. The worksheet contains named ranges
that correspond to the labels in Row 1.
Sometimes, the counting criteria are based on cells other than the cells being counted. You
might, for example, want to count the number of sales that meet the following criteria:
h Month is January, and
h SalesRep is Brooks, and
h Amount is greater than 1000
Figure 116-1: This worksheet demonstrates various counting techniques that use multiple criteria.
The following formula (for Excel 2007 and later only) uses three sets of paired arguments to
return the count: