I want to use a formula to count how many rows meet a set of two criteria.

[VivatMartin]

Hi again all,

I am hoping that you may be able to provide me an answer as to how I will be able to use a formula to define two sets of criteria. Namely, I want it to be able to meet a set year, so for exmaple, I have a column named "Year End, with values in it ranging: 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, and a column named "compliant" with values Yes and No. I want a formula to count what rows meet the criteria of 2005 and Yes. so that I am able to attain a % compliant.

Here's hoping you smart people out there are are smiling down upon me.

Many thanks,
Martin

[NBVC]

if you have excel 2000, you will need SUMPRODUCT

eg.

=Sumproduct(--(A2:A100=2005),--(B2:B100="yes"))

[Fotis1991]

Deleted.

Countifs can not work in Excell 2000

[VivatMartin]

if you have excel 2000, you will need SUMPRODUCT

eg.

=Sumproduct(--(A2:A100=2005),--(B2:B100="yes"))

Thank you Very much! This worked a treat, have added to your reputation...

Many thanks once again for a speedy and excellent reply.