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:

=COUNTIFS(Month,”January”,SalesRep,”Brooks”,Amount,”>1000”)