Default Calculation Sales % From Multy Level

LearnMeExcel

Well-known Member
Joined
Aug 11, 2009
Messages
728
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

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</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)

<thead>
</thead><tbody>
</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
 

Forum statistics

Threads
1,085,519
Messages
5,384,157
Members
401,884
Latest member
yashmailbox

Some videos you may like

This Week's Hot Topics

Top