Excel formula to check a range for blanks and another cell for a value

[tunna991]

I am stuck with a formula. Basically I want to check if a range of cells is blank, and then another cell which has the word "Yes" in it. If all that is true then condition should be a true or false if not.

Here is a breakdown of the tables:

The formula I am using is as follows.

=IF(NOT(COUNTA(O3:T3,W3="Yes),"Yes","No")

 

[SkipVought]

Hi,
[tt]
=IF(AND(SUM(ISBLANK(O3:T3))=0,W3="YES"),"YES","NO")
[/tt]
...and entered as an Array Formula.

Unchecked, from my iPhone.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]