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 corresponding cells.

Figure 17-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.
Several of the examples in this section use the COUNTIFS function, which is new to Excel 2007. I also present alternative versions of the formulas, which should be used if you plan to share your workbook with others who don’t use Excel 2007.

FIGURE 17-2
This worksheet demonstrates various counting techniques that use multiple criteria.

• Value Added Tax (VAT):  The Pros and Cons Over in the far off distant world of Europe, they don't use the income tax system that the American government...
• My Journey’s July 16th 2009 Update One of the main reasons I started this site was to keep myself accountable to anyone that was reading. Ironic...
• Racquet Review- Wilson K Factor Six One Tour 90 Racquet - Wilson K Factor Six One Tour 90 Length - 27 inches / 69 centimeters Head Size - 90...
• The High Cost of Modern Living This is a guest post from Robert Brokamp of The Motley Fool. Robert is a Certified Financial Planner and the...
• Using Whole Life Insurance to Create a Pension Income Stream Today I am presenting a guest post from a fellow personal finance blogger who proposes an interesting strategy for using...