Hi all,

Any idea for this formula

A * B + A1*B1 + .... divide (/) total B


Column A Column B Column C Formula
Sony A 10
Sony B 5
Sony A 9
Sony B 6



I want in the Formula Column

if Column A = Sony then
[(Column B -> A -> Column C 10 )*(Column B -> B -> Column B 6 )] / TOTAL Column B -> B

(10*5)+(5*6)/(5+6)

Thanks