Hi,

I have a sheets, in which Col A has supplier names, Col B has part
supplied by the supplier and Col C has qty supplied.

Supplier         Part          qty
AAAAA          XXXX        2222
AAAAA          1111        232
AAAAA          wwas       334
BBBBB          ******       345
BBBBB          ++++       675
BBBBB          ####        7876

Now i want to calculate the total qty for one supplier and then in
another col get the ratio of a qty for part by the total number of qty
for that supplier. With the above example:

it should calculate, first the total# of qty for Supp: AAAAA and then
each part qty for supplier AAAAA has to be divided by the total number
of qty for Supplier: AAAAA.

I know this sounds confusing, but this is i want.

Please help.

Thanks,
Navin