=SUMPRODUCT(--(Development!$H$4:$H$42=A5),--(Development!$J$4:$J$42>0),Development!$P$4:$P$42)
THis is my formula but rather than adding them together I need the weighted average of the answer based on another array G:G if the above conditions are matched?
Does this make sense?
Kitty g
THis is my formula but rather than adding them together I need the weighted average of the answer based on another array G:G if the above conditions are matched?
Does this make sense?
Kitty g