Once again, what do you expect O11:O17=O18 to return?

More specifically to the point,

=SUM((O11:O17=O18)*(P11:P17=P18)*(Q11:Q17=Q18)*(R1 1:R17=R18))

seems no different from

=SUM((O11=O18)*(P11=P18)*(Q11=Q18)*(R11=R18))

Is that how you intend it be used?

Alan Beban


PST wrote:
how to apply this matric in vba by replacing
O11:O17 by Myarray_1
p11:p17 by Myarray_2
q11:q17 by Myarray_3
r11:r17 by Myarray_4


=SUM((O11:O17=O18)*(P11:P17=P18)*(Q11:Q17=Q18)*(R1 1:R17=R18))


Thank you