L
Lance
COLUMN
A B C E
Customer QTY
A 16% 20 <-C2 123
B 15% 18 <-C3
C 25% 31
D 9% 11
E 10% 12
F 25% 31
123
In column C2 =ROUND(E2*B2,0)
In column C3 =ROUND(SUM($B$2:B3)*$E$2,0)-SUM($C$2:C2)
copy c3 down
Lance
A B C E
Customer QTY
A 16% 20 <-C2 123
B 15% 18 <-C3
C 25% 31
D 9% 11
E 10% 12
F 25% 31
123
In column C2 =ROUND(E2*B2,0)
In column C3 =ROUND(SUM($B$2:B3)*$E$2,0)-SUM($C$2:C2)
copy c3 down
Lance