Countif multiple column criteria

[Stacy Hill]

I need help with a count:

I am using Excel 2003.

I have three columns

A B C
Record ID Year Criticality
1 2006 Critical
2 2006 High
3 2007 Critical
4 2006 Critical
5 2007 Medium
6 2006 High
7 2006 High

What I need is a way to count where the record is in 2006 AND
Critical.

For 2006 Critical, I should end up with 2
2006 high I should end up with 3, etc.

I have tried many variations of formulas and nothing works.
I appreciate any help. Thanks.

Stacy

 

[Don Guillett]

=sumproduct((b2:b22=2006)*(c2:c22="critical"))

 

[Max]

Broaden your horizon. Try a pivot. Easy-to-use, powerful summarizer. In
Layout step, drag n drop Year & Criticality into ROW area, Criticality below
Year. Drag n drop Criticality into DATA area (it'll show COUNT). Click
OK>Finish. Check out the pivot results ...