Spreadsheet: 31768d1227718136-calculate-the-quantity-of-each-size-of-an-item-calculate-the-quantity-of-each-size-of-an-item
Sheet: Sheet3

Item | Kit 1 |  |  |  | Kit2 |  |  |  | LS Jersey |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Cycling Jersey |  |  |  | Cycling Shorts |  |  |  | Tri Suit |  |  |  | Bibs |  |  |  | Total
Price | 120 |  |  |  | 160 |  |  |  | 70 |  |  |  | 50 |  |  |  | 50 |  |  |  | 50 |  |  |  | 50 |  |  |  | 167 |  |  |  | 85
Name | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total | Quantity | Price | Size | Sub Total
[NAME] | 1 | 120 | S | 120 | 1 | 160 | S | 160 | 1 | 70 | S | 70 | 1 | 50 | S | 50 | 1 | 50 | S | 50 | 1 | 50 | S | 50 | 1 | 50 | S | 50 | 1 | 50 | S | 50 | 1 | 50 | S | 50 | 550
Ramsey | 2 | 120 | M | 240 | 2 | 160 | M | 320 | 2 | 70 | M | 140 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 1100
 |  | 120 |  | 0 | 3 | 160 | S | 480 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 480
 |  | 120 |  | 0 | 4 | 160 | M | 640 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 640
 |  | 120 |  | 0 | 5 | 160 | S | 800 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 800
 |  | 120 |  | 0 | 6 | 160 | M | 960 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 960
 |  | 120 |  | 0 | 7 | 160 | S | 1120 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 1120
 |  | 120 |  | 0 | 8 | 160 | M | 1280 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 1280
 |  | 120 |  | 0 | 9 | 160 | S | 1440 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2 | 50 | M | 100 | 2 | 50 | M | 100 | 1440
 |  | 120 |  | 0 | 10 | 160 | M | 1600 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 1600
 |  | 120 |  | 0 | 11 | 160 | S | 1760 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 1760
 |  | 120 |  | 0 | 12 | 160 | M | 1920 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 1920
 |  | 120 |  | 0 | 13 | 160 | S | 2080 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2080
 |  | 120 |  | 0 | 14 | 160 | M | 2240 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 2240
 |  | 120 |  | 0 |  | 160 |  | 0 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 0
 |  | 120 |  | 0 |  | 160 |  | 0 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 0
 |  | 120 |  | 0 |  | 160 |  | 0 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 0
 |  | 120 |  | 0 |  | 160 |  | 0 |  | 70 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 |  | 50 |  | 0 | 0
TOTALS | 3 |  |  | 360 | 105 |  |  | 16800 | 3 |  |  | 210 | 3 |  |  | 150 | 3 |  |  | 150 | 3 |  |  | 150 | 3 |  |  | 150 | 17 |  |  | 850 | 17 |  |  | 850 | 17970
Size Totals | Kit 1 |  |  |  | Kit2 |  |  |  | LS Jersey |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Cycling Jersey |  |  |  | Cycling Shorts |  |  |  | Tri Suit |  |  |  | Bibs
 | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0 |  | XS |  | 0
 | S |  | 1 |  | S |  | 7 |  | S |  | 1 |  | S |  | 1 |  | S |  | 1 |  | S |  | 1 |  | S |  | 1 |  | S |  | 1 |  | S |  | 1
 | M |  | 1 |  | M |  | 7 |  | M |  | 1 |  | M |  | 1 |  | M |  | 1 |  | M |  | 1 |  | M |  | 1 |  | M |  | 8 |  | M |  | 8
 | L |  | 0 |  | L |  | 0 |  | L |  | 0 |  | L |  | 0 |  | L |  | 0 |  | L |  | 0 |  | L |  | 0 |  | L |  | 0 |  | L |  | 0
 | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0 |  | XL |  | 0