Trying to figure out a specific IF, THEN rule

Copper Contributor

What I'm aiming for is a simple, (If H5 through H10 all show "yes", then D4 should show "yes". If any cell H5 down through H10 show a "no", then D4 should show "no".)


I've tried a few things but have been running into a brick wall. Anyone have an idea?


Thank you!

Corey Piazza

4 Replies




That yields a "There's a problem with this formula."
best response confirmed by FNCoreyP (Copper Contributor)




An alternative could be with COUNTIF.

Thank you, OliverScheurich, that worked!