Trying to figure out a specific IF, THEN rule

[FNCoreyP]

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

[#2]

@FNCoreyP 

=IF(AND(H5:H10="yes"),"yes","no")

[#3]

That yields a "There's a problem with this formula."

[#4 · Accepted solution]

@FNCoreyP 

=IF(COUNTIF(H5:H10,"yes")=6,"yes","no")

An alternative could be with COUNTIF.

[#5]

Thank you, OliverScheurich, that worked!