Distribution of amount using If Cond / any other function / by VBA

[Guest]

If any one can please guide me as how to distribute the amount in one row to
other rows. Here the other rows keep on changing. For eg :

A B C
Name Amount Allocation on Total Amount
A 10 12.5
B 20 25
C 10 12.5
Total 40 50
D 50 0

X 30 6
Y 20 4
Total 50 10
Z 10 0

Pls let me know if there is any logical program or formula wherein I will be
able to apply it for the whole data at a time. It should check the "name"
Column and allocate as per the formula. Kindly help.

 

[vezerid]

If any one can please guide me as how to distribute the amount in one row to
other rows. Here the other rows keep on changing. For eg :

A B C
Name Amount Allocation on Total Amount
A 10 12.5
B 20 25
C 10 12.5
Total 40 50
D 50 0

X 30 6
Y 20 4
Total 50 10
Z 10 0

Pls let me know if there is any logical program or formula wherein I will be
able to apply it for the whole data at a time. It should check the "name"
Column and allocate as per the formula. Kindly help.

In C2 (row of "A"):
=B2*$D$2/$B$4

HTH
Kostis Vezerides