Sumproduct With loop

[nba_abc]

Hello everyone,

I'm trying to create a loop with a sumproduct function.
I can use the classic sumproduct function without VBA but my file can contain thousands of lines.
in the attached file, sheet "result expected" I present the results i wish to obtain.

Thanks a lot for your help,
Kind regards,

[nba_abc]

Hello everyone,

Does anyone have any ideas on this?

Thanks a lot,
Kind regards

[protonLeah]

Please Login or Register  to view this content.

[nba_abc]

Hello protonLeah,

Thanks a lot for your help! This is what I've been looking for!

However, when I extend the table into sheet "products" and "stock" to reach line 10, I have this message: "Run time error 9: “Subscript out of Range”
Do you have a solution?

Thank you,
Kind regards

[protonLeah]

Small change. The result array needs # columns = # rows in prod and stock sheets, so:

ReDim resultarray(1 To UBound(ProductArray, 1), 1 To UBound(ProductArray, 1))

[nba_abc]

Hello protonLeah,

Thanks a lot, this is perfect!

Kind regards