Weighted Average Dynamic Arrays

[TripleA]

I'm trying to get a weighted average by rows for a dynamic array. I'm basically trying to reproduce a Sumproduct()/SUM() function but its just returns one whole number for the whole array.

I know it will be something around BYCOL, LET or/and LAMBDA but would appreciate if someone has already done this before.

 

[RobP]

could you share example data from your array so people on here are able to view it with a little more ease of understanding please ?

 

[TripleA]

could you share example data from your array so people on here are able to view it with a little more ease of understanding please ?

Sorry for the rustic approach but this is basically what Im trying to achieve but making the formula on Row 5 dynamic array based