View Single Post
  #5   Report Post  
 
Posts: n/a
Default

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)