=COUNTIFS(A1:D1,"yes")+0
or
=ISNUMBER(MATCH("yes",A1:D1,0))+0
Custom format the formula cell as:
[=0]"";[>0]"yes";General
Not liking that formula I’m afraid...
Seems a tricky one to crack,
Was close on =if(countif(A1:D1,’’’’),’’’’,IF,(COUNTIF)A1:D1,’’NO,IF(COUNTIF(A1:D1,’’yes’’)=4,”yes”)))
Unfortunately this only returns yes if all 4 cells say yes when I want it to return yes if any cell in that range is yes