• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Looking for all combinations to add up to 3

But why avoid SUMPRODUCT also, i.e. by inserting an additional function (MMULT) into a standard SUM construction? This additional function will cost more resource and I'm not sure I see the point.

Regards
 
This is really a good opportunity to ask you about the comparison between SUMPRODUCT vs sum(MMULT,According to your response I understand that in this case there is an advantage to SUMPRODUCT ?

If you remember once, we did a test about the comparison between sum {} vs SUMPRODUCT ,had a slight advantage to sum even if the situation of the array.

David
 
I seem to recall that discussion being about this use of MMULT to avoid CSE, not SUMPRODUCT, though I may be wrong.

In any case, the only difference between your construction and mine is that you have inserted an additional function (MMULT). I can only imagine that this can add to calculation time.

Regards
 
Hi @Jack-P-Winner,

I promised you all the 10000, 10 ^ 4, if you want the data in four columns, there will be no problem.

David
 

Attachments

  • DIGIT 4.xlsb
    100.4 KB · Views: 5
You must log in or register to reply here.
Back
Top