Summation

  • Thread starter Thread starter navin
  • Start date Start date
N

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
 
Back
Top