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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2