Notice in B6 and B7 the formula returns "No", when, in fact, the four consecutive "N"egative results are in K6:N6 and J7:M7.
As I showed and as DO mentioned: adjust the cell references.

It must be $G$6:$S$6 ( not $Z$6 )