Hi, Lynn-
You could count the Ns and blanks; the opposite way to think of that
same scenario is the absence of Ys. If you like that logic, you can
use the formula
=IF(COUNTIF(A1:F1,"Y")=0,"Y","")
.... to put a Y in column G.