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