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

Thank you for your reply



To know the number of Value between two Values
Array_1 do not have reference on the excel sheet of counting

what wants that's exactly, but it do not work.
the values of MyArray_1 are righteous man an example

Sub test_mat_array()
Array_1 = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
test_2 = Application.WorksheetFunction.Sum((Array_1 = 1) * (Array_1 <= 5))
Cells(1, 1) = test_2

End Sub


Alan Beban a écrit :
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

Sorry. Syntax Array_1 = 1 and Array_1 <= 5 I am not familiar with. I
can't see what you're intending.

Alan Beban

PST wrote:
Thank you for your reply



To know the number of Value between two Values
Array_1 do not have reference on the excel sheet of counting

what wants that's exactly, but it do not work.
the values of MyArray_1 are righteous man an example

Sub test_mat_array()
Array_1 = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
test_2 = Application.WorksheetFunction.Sum((Array_1 = 1) * (Array_1 <= 5))
Cells(1, 1) = test_2

End Sub


Alan Beban a écrit :

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