Accumulated Percentage

[delder]

I need to write a formula to show accumulated percentage units sold. Example: Col A = Part Number
Col B = Price
Col C = Units Sold
Col D = B*C
Col D is summed
Col E = D/Sum of D (Sort on E Highest to lowest)
Col F = incremental sum of each of the rows above

 

[Barrie Davidson]

On 2002-10-31 16:54, delder wrote:
I need to write a formula to show accumulated percentage units sold. Example: Col A = Part Number
Col B = Price
Col C = Units Sold
Col D = B*C
Col D is summed
Col E = D/Sum of D (Sort on E Highest to lowest)
Col F = incremental sum of each of the rows above

F1 =D1
F2 =F1+D2
F3 =F2+D3,
etc.

Regards,