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!
Bookmarks