=SUMPRODUCT((MOD(COLUMN(G2:M20)-COLUMN(G2),2)=0)*(G2:M20=--"2008-05-08")*(H2:N20="Passed"))

--
__________________________________
HTH

Bob

"aimee" wrote in message
...

What formula should I use to count how many cells in columns G,I,K,M
contain
8-May and how many cells in columns H,J,L,N contain Passed (for example)?