best way to count something in one column using criteria in another column

[Hankjam]

Hi
I would like to know the best way to count the number of cells that
have Pass in one column but only covering those in week 20 in another
column

A B

19 Pass
19 Pass
19 Fail
19 Pass
20 Pass
20 Fail
20 Pass
21 Fail
21 Pass

Thank you very much

Hj

 

[Claus Busch]

Hi,

Am Wed, 23 May 2012 19:45:24 +0100 schrieb Hankjam:

I would like to know the best way to count the number of cells that
have Pass in one column but only covering those in week 20 in another
column

19 Pass
19 Pass
19 Fail
19 Pass
20 Pass
20 Fail
20 Pass
21 Fail
21 Pass

in versions < 2007:
=SUMPRODUCT(--(A1:A100=20),--(B1:B100="Pass"))
xl2007 or xl2010:
=COUNTIFS(A:A,20,B:B,"Pass")


Regards
Claus Busch

 

[Hankjam]

=SUMPRODUCT(--(A1:A100=20),--(B1:B100="Pass"))

Hi Claus

Works a treat, many thanks
Hj