Formula is true if proportion of range is true

[nussbaum]

Trying for true / yes result if at least 50% of range meets criteria eg
=IF(AND O2="yes",H2<>"",I2<>"",J2<>"",K2<>"",L2<>"",M2<>"",N2<>""),"yes","no")
where O2 must be yes and input is required for at least 4 out of 7 cells
between H2 and I2
thank you

 

[CLR]

=IF(AND(O2="yes",COUNTA(H2:N2)>3),"True","False")

Vaya con Dios,
Chuck, CABGx3

 

[Max]

Try:

=IF(AND(O2="yes",SUMPRODUCT(--(H2:N2<>""))>=4),"yes","no")

 

[Max]

Try:

=IF(AND(O2="yes",SUMPRODUCT(--(H2:N2<>""))>=4),"yes","no")

Clarification: It's presumed that the range H2:N2 may also contain formulas
which could evaluate to null: "". Using SUMPRODUCT is one way to handle this
possibility.