Need a formula divide to individual dan total up all of it.

[choy96]

Each quantity must be divide by the group value to get the weight and total up it.
Please see the attachment.

thanks

[Special-K]

In E9

=D9/VLOOKUP(C9,B$3:C$6,2,FALSE)

and copy down the column
Delete E14 contents (the #N/A)

in
B22
=SUMIF(B9:B17,"=TBA",D9:D17)

and format as a number (it's currently a date)

[choy96]

thanks special-k, but i do not add 1 more column to my table, i believe have 1 formula in B22 straight can get the total .

[Haseeb Avarakkan]

You have attached xlsx version. So assume you are using XL2007 or later. Try this,

=SUM(IFERROR(IF(B9:B17=B21,D9:D17)/SUMIF(B3:B6,IF(B9:B17=B21,C9:C17),C3:C6),0))

Confirmed with CTRL+SHIFT+ENTER.