Spreadsheet: 675260d1588222777-help-with-summing-an-grid-with-a-single-criteria-sumif-or-sum-if-or-sumproduct-excel-formula-help
Sheet: FW21

 |  |  |  |  |  |  |  | CAPSULE 1 |  |  |  |  | CAPSULE 2 |  |  |  |  | CAPSULE 3 |  |  |  |  | CORE |  |  |  |  | VOYAGE
. |  |  |  |  |  |  |  | Grained | [NAME] | Lizard | Lizard | Python | Grained | Grained | Croc | Leopard | TBC | Grained | Grained | Croc | Python | Puffy | Grained | Grained | Bulle | [NAME] | [NAME] | Dakota | Dakota
Name | Function | Status | Collection | AVG FALL 20 ST % | RRP Bracket (NZD) | [NAME] | Comments | Bamboo | Foxglove | Black | Foxglove | Sepia | Espresso | Honey | Toffee | Toffee | TBC | Forest | Seashadow | Black | Noir | Black | Black | Elephante | Black | Black | TBC | Black | Forest | NEW SAMPLE REQUEST SUBTOTAL BY STYLE
Mr Boxette Grande | Clutch | New |  |  | 500-699 | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  | x | x | x | x | x | x
Mr [NAME] | Clutch | New |  |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Mr [NAME] | Tote | New |  |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Mr [NAME] (Chain) | Cross Body | New |  |  |  | WK |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Mr [NAME] | Tote | New | CORE |  |  | WK? |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  | x | x | x | x
Mr Micro Sling | [NAME] | New | CAPSULE |  |  | WK |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
[NAME] | SLG | New |  |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Comet Mini | Cross Body | New | VOYAGE |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
[NAME] | SLG | New | VOYAGE |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Mini Notebook Cover | SLG | New | VOYAGE |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Phone Pouch | SLG | New | VOYAGE |  |  | MA |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
[NAME] | [NAME] | New |  |  |  | WK |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
SUBTOTAL
SKU COUNT | Target
 | 230
TOTAL STYLES | CORE | CAPSULE | VOYAGE
 | 0.35 | 0.5 | 0.15
FUNTIONALITY | % of Total |  |  |  | PRICE BRACKET | % of Total
[NAME] |  |  |  |  | 0-299
 |  |  |  |  |  |  | 0.28
Cross Body |  |  |  |  | 300-499
 |  |  |  |  |  |  | 0.25
Shoulder |  |  |  |  | 500-699
 |  |  |  |  |  |  | 0.23
Tote |  |  |  |  | 700-899
 |  |  |  |  |  |  | 0.21
Clutch |  |  |  |  | 900-1099
 |  |  |  |  |  |  | 0.02
Business |  |  |  |  | 1100 +
 |  |  |  |  |  |  | 0.01
[NAME]
Back Pack
Travel
SLG
Accessory
8