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

  • Thread starter Thread starter Hankjam
  • Start date Start date
H

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
 
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
Click to expand...
19 Pass
19 Pass
19 Fail
19 Pass
20 Pass
20 Fail
20 Pass
21 Fail
21 Pass
Click to expand...

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


Regards
Claus Busch
 
Back
Top