Item I.D. Cost Total Packs
a 200 136540
b 200 133530
c 200 72920
d 200 40340
e 200 290120
f 200 471520
g 200 0


I could do with some help if any one could! I need to find the proportionate
cost of each item. For example if the total packs of A-G was 100 and A alone
was 50 it would recieve half of the cost (100). However, even though g says
it is 0 i need to allocate 1% of the cost to this item and making all the
other costs still = 200. I have an easy formula should the 0 not occur (in
other sheets) but i can't figure out how to do this.

Help would be HUGELY appriciated!!! Thanks!