Spreadsheet: 128463d1320970111-sum-product-range-paul-master-working-sum-product
Sheet: Customer

 | Select a Product Group |  |  |  | Cutomer Number
 | AND / OR |  |  |  | 3152
 | Georgian
 | AND / OR
 | Spacer
 | AND / OR
 | Textured
 | [NAME]
 | Product Group | [NAME] | Spacer | Textured | Georgian | Price | Volume | Revenue | Volume |  | Product | Volume
 | EnergiKare | Annealed | Aluminium | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Super | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Swiss | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | TGI | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Aluminium | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Super | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Swiss | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | TGI | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Aluminium | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Super | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Swiss | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | TGI | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Aluminium | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Super | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Swiss | No | No | 0 | 0 | 0 | #N/A |  | Example
 | [NAME] | Toughened | TGI | No | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Aluminium | No | No | 0 | 0 | 0 | #N/A |  | Product | Volume
 | Triple Glazed | Annealed | Super | No | No | 0 | 0 | 0 | #N/A |  | EnergiKare | 0
 | Triple Glazed | Annealed | Swiss | No | No | 0 | 0 | 0 | #N/A |  | [NAME] | 0
 | Triple Glazed | Annealed | TGI | No | No | 0 | 0 | 0 | #N/A |  | Triple Glazed | 0
 | Triple Glazed | Toughened | Aluminium | No | No | 0 | 0 | 0 | #N/A |  | Laminated | 28.36
 | Triple Glazed | Toughened | Super | No | No | 0 | 0 | 0 | #N/A |  | Other | 270.39
 | Triple Glazed | Toughened | Swiss | No | No | 0 | 0 | 0 | #N/A |  | ST | 0
 | Triple Glazed | Toughened | TGI | No | No | 0 | 0 | 0 | #N/A |  | [NAME] | 0
 | Laminated | Annealed | Aluminium | No | No | 47.00634696755995 | 28.36 | 1333.1 | 28.36
 | Laminated | Annealed | Super | No | No | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Swiss | No | No | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | TGI | No | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Super | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Super | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Super | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Super | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Super | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Super | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Aluminium | Yes | No | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Super | Yes | No | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Super | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Super | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Super | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Super | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Super | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Super | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Super | No | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Annealed | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | EnergiKare | Toughened | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Annealed | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Annealed | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | Triple Glazed | Toughened | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | Laminated | Annealed | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | Aluminium | No | No | 18.75494030465212 | 194.32 | 3644.46 | 194.32
 | Other | Annealed | Super | No | No | 0 | 0 | 0 | #N/A
 | Other | Annealed | Swiss | No | No | 0 | 0 | 0 | #N/A
 | Other | Annealed | TGI | No | No | 0 | 0 | 0 | #N/A
 | Other | Toughened | Aluminium | No | No | 28.00939716312057 | 56.4 | 1579.73 | 56.4
 | Other | Toughened | Super | No | No | 0 | 0 | 0 | #N/A
 | Other | Toughened | Swiss | No | No | 0 | 0 | 0 | #N/A
 | Other | Toughened | TGI | No | No | 0 | 0 | 0 | #N/A
 | Other | Annealed | Aluminium | Yes | No | 30.20549242424243 | 10.56 | 318.97 | 10.56
 | Other | Annealed | Super | Yes | No | 0 | 0 | 0 | #N/A
 | Other | Annealed | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | Other | Annealed | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | Other | Toughened | Aluminium | Yes | No | 43.76723016905071 | 7.690000000000001 | 336.5700000000001 | 7.690000000000001
 | Other | Toughened | Super | Yes | No | 0 | 0 | 0 | #N/A
 | Other | Toughened | Swiss | Yes | No | 0 | 0 | 0 | #N/A
 | Other | Toughened | TGI | Yes | No | 0 | 0 | 0 | #N/A
 | Other | Annealed | Aluminium | No | Yes | 43.87323943661972 | 1.42 | 62.3 | 1.42
 | Other | Annealed | Super | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | Aluminium | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | Super | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | Swiss | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | TGI | No | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Annealed | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | Aluminium | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | Super | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | Swiss | Yes | Yes | 0 | 0 | 0 | #N/A
 | Other | Toughened | TGI | Yes | Yes | 0 | 0 | 0 | #N/A
 | ST | Toughened | No Spacer | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Aluminium | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Super | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | Swiss | No | No | 0 | 0 | 0 | #N/A
 | [NAME] | Toughened | TGI | No | No | 0 | 0 | 0 | #N/A