haf wrote...
i've tried like this
=IF((D5:H5;K5:N5)="+",COUNTBLANK(1:1)<3)
but doesn't work
....
(D5:H5;K5:N5)="+" is a syntax error. Do you mean
OR(D5:H5="+",K5:N5="+")
? If so, you'd need to enter the formula
=IF(OR(D5:H5="+",K5:N5="+"),COUNTBLANK(1:1)<3)
as an array formula. Alternatively, you could use the following, longer
non-array formula.
=IF(COUNTIF(D5:H5,"+")+COUNTIF(K5:N5="+"),COUNTBLA NK(1:1)<3)
|