Formula required - IF a range and a cell

[MattKoleczko]

Column B - Cell contains either Yes or it's Blank
Columns Q to AD - Cells contain either Yes, Standby or Blank

If Columns Q to AD contains a Yes, return Yes (ignore Standby), however, if Column B has a Yes, return No.

I've been playing with the following formula, but it's not producing the desired result
=IF(COUNTIF(Q3:AD3,"*"&"Yes"&"*"),"Yes",IF(B3="Yes","No"))

Thanks for the help!

[way2020]

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you
have removed any private information, remember this is a public forum and so available to anyone.
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

Just before posting, scroll down to GO ADVANCED, click, and then scroll
down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[MattKoleczko]

AE3 is correct
AE2 should read No

[bebo021999]

=IF(B2="Yes","No",IF(COUNTIF(Q2:AD2,"Yes"),"Yes",""))

[MattKoleczko]

I swear I tried this combo *insert facepalm

Cheers,
Matt