Sumproduct with dynamic array

[IoanZ]

Hello to every one, Ioan here

I don't succeed to create dynamic array for range of cells, this dynamic aaray will be usefull to aproximate a specific value:

Please watch the image to understand what i want to say

https://imgur.com/a/4vQHP

Thank's

 

[RobertSF]

Hi, Ioan, and sorry, but I could not figure it out with formulas. This problem reminds me of "linear programming." Perhaps you can google "excel linear programming" It's a difficult challenge, I think

 

[IoanZ]

ok, thanks for your suggestion, i will search

 

[pgc01]

Hi Ioan

You try use the solver to solve this type of problems.

For ex., in this case you have an exact match: 680 = 4 * 120 + 200