=IF(COUNTIF(E2:I2,"y")=5,"YES","NO")
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

wrote in message
...
Hello,

Trying to come up with a formula which would do - if A through E =Y
then H = YES else NO

i started with this but it does not work. =IF((E2:I2 = y), "YES","NO")


A B C D E H
Y Y Y Y Y
Y Y Y N Y

Thanks for the help!