Spreadsheet: 120445d1315309469-creating-an-auto-populating-order-summary-sheet-sept-order-form
Sheet: C

C Jan 2011
Item Code | Category | Description | [NAME] | Discount % | Promo | Total Discount | Trade | RRP | Qty | Nett | Total
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 26.66 | 47.988
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 40.82777777777778 | 73.49
c | d | bow | B | 0.25 |  |  | 45.55 | 81.99
c | d | bow | B | 0.25 |  |  | 45.55 | 81.99
c | d | bow | B | 0.25 |  |  | 65.82777777777777 | 118.49
c | d | bow | B | 0.25 |  |  | 65.82777777777777 | 118.49
c | d | bow | B | 0.25 |  |  | 45.55 | 81.99
c | d | bow | B | 0.25 |  |  | 45.55 | 81.99
c | d | bow | B | 0.25 |  |  | 65.82777777777777 | 118.49
c | d | bow | B | 0.25 |  |  | 65.82777777777777 | 118.49
c | d | bow | A | 0.5 |  |  | 7.216666666666668 | 12.99
c | d | bow | A | 0.5 |  |  | 7.772222222222222 | 13.99
c | d | bow | A | 0.5 |  |  | 8.327777777777778 | 14.99
c | d | bow | A | 0.5 |  |  | 8.883333333333335 | 15.99
c | d | bow | A | 0.5 |  |  | 9.438888888888888 | 16.99
c | d | bow | A | 0.5 |  |  | 10.55 | 18.99
c | d | bow | A | 0.5 |  |  | 12.77222222222222 | 22.99
c | d | bow | A | 0.5 |  |  | 11.66111111111111 | 20.99
c | d | bow | A | 0.5 |  |  | 5.550000000000001 | 9.99
c | d | bow | A | 0.5 |  |  | 5.827777777777778 | 10.49
c | d | bow | A | 0.5 |  |  | 6.105 | 10.989
c | d | bow | A | 0.5 |  |  | 6.661111111111111 | 11.99
c | d | bow | A | 0.5 |  |  | 7.772222222222222 | 13.99
c | d | bow | A | 0.5 |  |  | 8.327777777777778 | 14.99
c | d | bow | A | 0.5 |  |  | 9.438888888888888 | 16.99
c | d | bow | A | 0.5 |  |  | 8.883333333333335 | 15.99
c | d | bow | A | 0.5 |  |  | 7.216666666666668 | 12.99
c | d | bow | A | 0.5 |  |  | 7.772222222222222 | 13.99
c | d | bow | A | 0.5 |  |  | 8.327777777777778 | 14.99
c | d | bow | A | 0.5 |  |  | 8.883333333333335 | 15.99
c | d | bow | A | 0.5 |  |  | 9.438888888888888 | 16.99
c | d | bow | A | 0.5 |  |  | 10.55 | 18.99
c | d | bow | A | 0.5 |  |  | 12.77222222222222 | 22.99
c | d | bow | A | 0.5 |  |  | 11.66111111111111 | 20.99
c | d | bow | B | 0.25 |  |  | 5.972222222222222 | 10.75
c | d | bow | B | 0.25 |  |  | 5.972222222222222 | 10.75
c | d | bow | B | 0.25 |  |  | 5.972222222222222 | 10.75
c | d | bow | B | 0.25 |  |  | 9.027777777777779 | 16.25
c | d | bow | B | 0.25 |  |  | 5.972222222222222 | 10.75
c | d | bow | B | 0.25 |  |  | 3.605555555555556 | 6.49
c | d | bow | B | 0.25 |  |  | 10.82777777777778 | 19.49
c | d | bow | C | 0.1 |  |  | 136.1055555555556 | 244.99
c | d | bow | C | 0.1 |  |  | 111.1055555555556 | 199.99
c | d | bow | C | 0.1 |  |  | 216.6611111111111 | 389.99
c | d | bow | C | 0.1 |  |  | 188.8833333333334 | 339.99
c | d | bow | A | 0.5 |  |  | 10.27222222222222 | 18.49
c | d | bow | A | 0.5 |  |  | 11.93888888888889 | 21.49
c | d | bow | A | 0.5 |  |  | 1.722222222222222 | 3.1
c | d | bow | A | 0.5 |  |  | 1.469503546099291 | 2.645106382978723
c | d | bow | A | 0.5 |  |  | 1.469503546099291 | 2.645106382978723
c | d | bow | A | 0.5 |  |  | 2.055555555555556 | 3.7
c | d | bow | A | 0.5 |  |  | 1.722222222222222 | 3.1
c | d | bow | A | 0.5 |  |  | 1.722222222222222 | 3.1
c | d | bow | A | 0.5 |  |  | 13.60555555555555 | 24.49
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 1.888888888888889 | 3.4
c | d | bow | A | 0.5 |  |  | 1.888888888888889 | 3.4
c | d | bow | A | 0.5 |  |  | 11.38333333333333 | 20.49
c | d | bow | A | 0.5 |  |  | 12.49444444444445 | 22.49
c | d | bow | A | 0.5 |  |  | 13.60555555555555 | 24.49
c | d | bow | A | 0.5 |  |  | 11.38333333333333 | 20.49
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 10.82777777777778 | 19.49
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 8.05 | 14.49
c | d | bow | A | 0.5 |  |  | 8.605555555555556 | 15.49
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 9.16111111111111 | 16.49
c | d | bow | A | 0.5 |  |  | 8.605555555555556 | 15.49
c | d | bow | A | 0.5 |  |  | 8.05 | 14.49
c | d | bow | A | 0.5 |  |  | 8.05 | 14.49
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | C | 0.1 |  |  | 3.972222222222223 | 7.15
c | d | bow | C | 0.1 |  |  | 16.66111111111111 | 29.99
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 0.8611111111111112 | 1.55
c | d | bow | A | 0.5 |  |  | 1.083333333333333 | 1.95
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 5.694444444444446 | 10.25
c | d | bow | A | 0.5 |  |  | 1.722222222222222 | 3.1
c | d | bow | A | 0.5 |  |  | 35.27222222222223 | 63.49
c | d | bow | A | 0.5 |  |  | 35.27222222222223 | 63.49
c | d | bow | A | 0.5 |  |  | 35.27222222222223 | 63.49
c | d | bow | A | 0.5 |  |  | 35.27222222222223 | 63.49
c | d | bow | A | 0.5 |  |  | 7.494444444444444 | 13.49
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 9.716666666666667 | 17.49
c | d | bow | A | 0.5 |  |  | 5.138888888888889 | 9.25
c | d | bow | A | 0.5 |  |  | 7.361111111111112 | 13.25
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 5.694444444444446 | 10.25
c | d | bow | A | 0.5 |  |  | 2.833333333333333 | 5.1
c | d | bow | A | 0.5 |  |  | 2.833333333333333 | 5.1
c | d | bow | A | 0.5 |  |  | 2.833333333333333 | 5.1
c | d | bow | A | 0.5 |  |  | 4.555555555555555 | 8.2
c | d | bow | A | 0.5 |  |  | 7.361111111111112 | 13.25
c | d | bow | A | 0.5 |  |  | 5.694444444444446 | 10.25
c | d | bow | A | 0.5 |  |  | 11.38333333333333 | 20.49
c | d | bow | A | 0.5 |  |  | 5.111111111111111 | 9.2
c | d | bow | A | 0.5 |  |  | 5.111111111111111 | 9.2
c | d | bow | A | 0.5 |  |  | 5.694444444444446 | 10.25
c | d | bow | A | 0.5 |  |  | 1.526241134751773 | 2.747234042553191
c | d | bow | A | 0.5 |  |  | 1.75 | 3.15
c | d | bow | A | 0.5 |  |  | 1.526241134751773 | 2.747234042553191
c | d | bow | A | 0.5 |  |  | 1.75 | 3.15
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 1.526241134751773 | 2.747234042553191
c | d | bow | A | 0.5 |  |  | 1.526241134751773 | 2.747234042553191
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 1.75 | 3.15
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 1.75 | 3.15
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 1.75 | 3.15
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 1.526241134751773 | 2.747234042553191
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 2.277777777777778 | 4.1
c | d | bow | A | 0.5 |  |  | 3.001418439716312 | 5.402553191489361
c | d | bow | A | 0.5 |  |  | 2.831205673758865 | 5.096170212765957
c | d | bow | A | 0.5 |  |  | 3.416666666666667 | 6.15
c | d | bow | A | 0.5 |  |  | 2.831205673758865 | 5.096170212765957
c | d | bow | A | 0.5 |  |  | 2.831205673758865 | 5.096170212765957
c | d | bow | A | 0.5 |  |  | 2.831205673758865 | 5.096170212765957
c | d | bow | A | 0.5 |  |  | 7.388888888888889 | 13.3
c | d | bow | A | 0.5 |  |  | 7.944444444444446 | 14.3
c | d | bow | A | 0.5 |  |  | 8.500000000000002 | 15.3
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 7.361111111111112 | 13.25
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 7.361111111111112 | 13.25
c | d | bow | A | 0.5 |  |  | 6.25 | 11.25
c | d | bow | A | 0.5 |  |  | 7.361111111111112 | 13.25
Stand Deals
d |  | e |  |  |  |  | 299.99 | - |  | 299.99
d |  | e |  |  |  |  | 299.99 | -
 |  |  |  |  |  |  |  |  | C Total £