See Formula Below

Brandon03

Count if issuer cell contains "Monkey" or "Bananas" and OK/NG CM does not contain "OK 3" if OK 3 return 0.

=COUNTIFS(ISSUER@row, HAS(@cell, "Monkey", OR("Bananas", [OK/NG CM]@row, FIND("OK 3", @cell) = 0)))

Paul Newcome

Try this...

=COUNTIFS(ISSUER@row, OR(CONTAINS("Monkey", @cell), CONTAINS("Bananas", @cell)), [OK/NG CM]@row, FIND("OK 3", @cell) = 0)

Paul Newcome

Try this...

=COUNTIFS(ISSUER@row, OR(CONTAINS("Monkey", @cell), CONTAINS("Bananas", @cell)), [OK/NG CM]@row, FIND("OK 3", @cell) = 0)