Hi,

I am trying to devise a formula that looks down a set of data, and look in
columns A and B for Year/Quarter and for each returns a count of whether
colum C is 10.
I can easily get to to count values 10 but not for those that occur in
specific Quarters.

Thanks for any and all help

Data looks as follows:

Yr Q No. of Cases
2008 1 10
2008 1 20
2008 1 30
2008 1 30
2008 1 30
2008 1 10
2008 1 10
2008 2 30
2008 2 30
2008 2 30
2008 2 10
2008 2 10
2008 2 10
2008 2 10
2008 2 10
2008 2 10
2008 3 30
2008 3 30
2008 3 30
2008 3 20
2008 3 20
2008 4 20
2008 4 20
2007 1 10
2007 1 30
2007 1 30
2007 2 30
2007 2 10
2007 2 10
2007 2 10
2007 3 10
2007 4 10
2007 4 10
2007 4 10
2007 4 30
2007 4 30