Conditional Countif function?

M

Miketsw

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
 
M

Mike H

Hi,

I've assumed that the years and quarters are numbers and not dates

=SUMPRODUCT((A2:A37=2008)*(B2:B37=1)*(C2:C37>10))

In practice I'd use cell references for the year and date

=SUMPRODUCT((A2:A37=H1)*(B2:B37=H2)*(C2:C37>10))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make chart from dates in a column 4
XIRR problem 5
XIRR problem 4
combine countif and sumproduct? 2
Conditional sum equals 0 4
Lookup by multiple criteria. 5
Convert Effective Annual ROR into quarterly ROR 2
Looking for a formula 3

Top