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.