Solved: incorporating condition or math into sumproduct

[grichey]

I'm trying to make a sumproduct statement conditional or with additional math. Math is probably the easiest as shown in example.


I have included a sample as this is better shown with an example I think.

[Bob Phillips]

Is this what you mean

=SUMPRODUCT((E5:E11)*(G5:G11-F5:F11))/SUMPRODUCT(G5:G11-F5:F11)

[grichey]

I think so. I'm going to go ahead and mark as solved regardless if it's not exactly right, it should be close enough to get me going.

thx.