• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reallocating the result from Sumproduct


New Member
Hi Guys,

I am spinning my head trying to figure this out. Maybe there is no way to do this but thought id post it here and hear it from the experts.

For a sum-product ...all we need is the weighting and the value to calculate the end result shown below

56%, 16%, 8%, 19% - (Composition)
0.65 ,0.74, 0.76, 0.95 - (Indivudual Price)
so the sum product of the above combination is 0.733 ( End result)

So what I am trying to figure out is say I have the (end result) 0.733 and (composition), is there a way to calculate the (individual price) without any more additional information