Reallocating the result from Sumproduct

[abhi2611]

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

 

[Peter Bartholomew]

No, it is not possible to determine the individual prices knowing just a weighted average (which is what your SUMPRODUCT provides). In your example, you have 4 unknown prices and one equation. That is not sufficient to determine the values.

 

[abhi2611]

Thanks for responding.