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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,089,673
Messages
5,409,649
Members
403,274
Latest member
Lewis1995

This Week's Hot Topics

Top