View Full Version : Solved: incorporating condition or math into sumproduct
grichey
06-24-2008, 09:42 AM
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
06-24-2008, 09:54 AM
Is this what you mean
=SUMPRODUCT((E5:E11)*(G5:G11-F5:F11))/SUMPRODUCT(G5:G11-F5:F11)
grichey
06-24-2008, 11:00 AM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.