Summation

[navin]

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

 

[Lori]

Try filling down in column D:

=C2/SUMIF(A:A,A2,C:C)