I can't seem to build the right formula to make this happen:

If a = "1" and b = "NO" and c = "NO" and d = "NO" show a "1" in e. If this criteria is not met add a "0" in e.

Some rows could have a "0" in a or a "YES" in b, c or d and I'm looing to eliminate those from my sum.

Thanks for your help!