Try this:

=SUMPRODUCT((B2:B81="no")*(C2:C81<"Production Issue"))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)



"FLChick" wrote in message
ups.com...
Can someone help me with this? I created the following statement but
it's not doing what I want it to do.

=IF(COUNTIF(B2:B81,"no"),COUNTIF(C2:C81,"<Product ion Issue"))

I want a count of the number of times "no" is in column B and
"Production Issue" are NOT in column C. The result I'm getting is a
total number of times "Production Issue" is not in column C,
regardless of what is in column B.


For example, I would want a count of 1 if I used the formula on the
data below (only the 3rd row has "no" in column B and does not have
"Production Issue" in column C).

A B C
966 yes
967 yes dupe of 966
968 no Violates BRs
969 no Production Issue
970 no Production Issue

Thanks!

June