Column AMT Customer1 Customer2 Customer3 Customer4 Common
Row A B C D(count)
2 Customer1 Customer3 Customer 2 3 / 150 50 50 50 0 0
3 Customer3 Customer 2 2 / 80 0 40 40
4 Customer 2 1 / 10 10
5 Customer 4 1 20 20
6 Common 12(cost divided to Customer1, 2 3 and 4) / 120 30 30 30 30
=IF(A:A=F1(customer1,D2/E2,IF(B:B=F1,D2/E2/AG9,IF(C:C=f1,D2/E2,
IF(AND(A:A=G1,D3/E3,B:B=g1,D3/E3,C:C=g1,D3/E3,
IF(AND(A:A=H1,D4/E4,B:B=h1,D4/E4,C:C=h1,D4/E4,
IF(AND(A:A=i1,D5/E5,B:B=i1,D5/E5,C:C=i1,D5/E5,
IF(AND(A:A=j1(common),D5/E5,B:B=j1,D5/E5,C:C=j11,D5/E5,
I want the "common" to divide it to customer 1, 2 3, and 4.
Kindly advice
Bookmarks