On Jun 18, 5:41 am, "Bob Phillips" wrote:
=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)?

Hey, Bob. Can you explain what your first argument is doing in that
formula? I don't mean to hijack, but maybe this would help the OP, too.