# Default Calculation Sales % From Multy Level

#### LearnMeExcel

##### Well-known Member
Hi
ABCDEFGHIJKLMNOP
1ProductSalesAABB
2A1326FT%1326FT%3365
3B336502000%200005000%5000
4A4412014000.50%200150110000.50%5002.5
5A6224016000.75%2001.5100115000.75%5003.75
6B79556018001%2002150120001%5005
7B543580110001.25%2002.5200125001.25%5006.25
8A538100112001.50%2003250130001.50%5007.5
9120114001.75%1262.205300135001.75%3656.3875
10140116002%350140002%
11160118002.25%400145002.25%
1218013%45013%
13total commision for 1st inovice 12.205total commision for 2st inovice 31.3875
14

</tbody>
Sheet1

Worksheet Formulas
CellFormula
I3=G3*H3
I4=G4*H4
I5=G5*H5
I6=G6*H6
I7=G7*H7
I8=G8*H8
I9=G9*H9
O3=M3*N3
O4=M4*N4
O5=M5*N5
O6=M6*N6
O7=M7*N7
O8=M8*N8
O9=M9*N9
I13=SUM(I3:I12)
O13=SUM(O3:O12)

</tbody>

<tbody>
</tbody>

in column A B my Sales Table

From Range E2:G12 Sales % For Product A

From Range K2:M12 Sales % for Product B

in Column H & i how i calculate the % for Each Transaction

and same steps in Column N & O

it takes long time to calculate % for my sales

any Idea please to Make it easier than my way

#### LearnMeExcel

##### Well-known Member
Hello any idea plz

is it hard case

#### LearnMeExcel

##### Well-known Member
i hope if any one can help