Spreadsheet: 150731d1334670564-index-match-or-sumproduct-with-concatenate-solution-to-problem
Sheet: Sales by Product

 |  |  | DATA ON THIS SHEET CAN NOT CHANGE!
 |  |  |  | Product 1 | Product 2 | Spacer | Product Group |  | Total M2 by Product |  |  |  | Total Sales by Product |  |  |  | Total Costs by Product
 |  |  |  | Product 1 |  | Aluminium |  |  | 360 |  | 360 |  | 95 |  | 95 |  | 41 |  | 41
 |  |  |  | Product 1 |  | [NAME] |  |  | 324 |  | 324 |  | 184 |  | 184 |  | 282 |  | 282
 |  |  |  | Product 1 |  | Aluminium |  |  | 474 |  | 474 |  | 214 |  | 214 |  | 34 |  | 34
 |  |  |  | Product 1 |  | [NAME] |  |  | 360 |  | 360 |  | 144 |  | 144 |  | 63 |  | 63
 |  |  |  | Product 1 |  | Aluminium |  |  | 398 |  | 398 |  | 105 |  | 105 |  | 98 |  | 98
 |  |  |  | Product 1 |  | [NAME] |  |  | 436 |  | 436 |  | 371 |  | 371 |  | 154 |  | 154
 |  |  |  | Product 1 |  | Aluminium |  |  | 246 |  | 246 |  | 84 |  | 84 |  | 21 |  | 21
 |  |  |  | Product 1 |  | [NAME] |  |  | 161 |  | 161 |  | 184 |  | 184 |  | 207 |  | 207
 |  |  |  | Product 1 |  | Aluminium |  |  | 379 |  | 379 |  | 370 |  | 370 |  | 169 |  | 169
 |  |  |  | Product 1 |  | [NAME] |  |  | 203 |  | 203 |  | 90 |  | 90 |  | 412 |  | 412
 |  |  |  | Product 2 |  | Aluminium |  |  | 134 |  | 134 |  | 305 |  | 305 |  | 212 |  | 212
 |  |  |  | Product 2 |  | [NAME] |  |  | 105 |  | 105 |  | 285 |  | 285 |  | 445 |  | 445
 |  |  |  | Product 2 |  | Aluminium |  |  | 373 |  | 373 |  | 118 |  | 118 |  | 246 |  | 246
 |  |  |  | Product 2 |  | [NAME] |  |  | 134 |  | 134 |  | 62 |  | 62 |  | 286 |  | 286
 |  |  |  | Product 2 |  | Aluminium |  |  | 308 |  | 308 |  | 219 |  | 219 |  | 269 |  | 269
 |  |  |  | Product 2 |  | [NAME] |  |  | 222 |  | 222 |  | 24 |  | 24 |  | 121 |  | 121
 |  |  |  | Product 2 |  | Aluminium |  |  | 423 |  | 423 |  | 447 |  | 447 |  | 86 |  | 86
 |  |  |  | Product 2 |  | [NAME] |  |  | 124 |  | 124 |  | 103 |  | 103 |  | 160 |  | 160
 |  |  |  | Product 2 |  | Aluminium |  |  | 182 |  | 182 |  | 260 |  | 260 |  | 78 |  | 78
 |  |  |  | Product 2 |  | [NAME] |  |  | 460 |  | 460 |  | 396 |  | 396 |  | 123 |  | 123
 |  |  |  | Product 3 |  | Aluminium |  |  | 114 |  | 114 |  | 72 |  | 72 |  | 201 |  | 201
 |  |  |  | Product 3 |  | [NAME] |  |  | 285 |  | 285 |  | 454 |  | 454 |  | 147 |  | 147
 |  |  |  | Product 3 |  | Aluminium |  |  | 348 |  | 348 |  | 429 |  | 429 |  | 261 |  | 261
 |  |  |  | Product 3 |  | [NAME] |  |  | 16 |  | 16 |  | 137 |  | 137 |  | 154 |  | 154
 |  |  |  | Product 3 |  | Aluminium |  |  | 215 |  | 215 |  | 48 |  | 48 |  | 137 |  | 137
 |  |  |  | Product 3 |  | [NAME] |  |  | 376 |  | 376 |  | 139 |  | 139 |  | 489 |  | 489
 |  |  |  | Product 3 |  | Aluminium |  |  | 393 |  | 393 |  | 146 |  | 146 |  | 42 |  | 42
 |  |  |  | Product 3 |  | [NAME] |  |  | 26 |  | 26 |  | 361 |  | 361 |  | 421 |  | 421
 |  |  |  | Product 3 |  | Aluminium |  |  | 209 |  | 209 |  | 37 |  | 37 |  | 103 |  | 103
 |  |  |  | Product 3 |  | [NAME] |  |  | 14 |  | 14 |  | 83 |  | 83 |  | 451 |  | 451
 |  |  |  | Product 4 |  | Aluminium |  |  | 388 |  | 388 |  | 57 |  | 57 |  | 267 |  | 267
 |  |  |  | Product 4 |  | [NAME] |  |  | 286 |  | 286 |  | 392 |  | 392 |  | 486 |  | 486
 |  |  |  | Product 4 |  | Aluminium |  |  | 14 |  | 14 |  | 461 |  | 461 |  | 351 |  | 351
 |  |  |  | Product 4 |  | [NAME] |  |  | 424 |  | 424 |  | 181 |  | 181 |  | 229 |  | 229
 |  |  |  | Product 4 |  | Aluminium |  |  | 474 |  | 474 |  | 202 |  | 202 |  | 192 |  | 192
 |  |  |  | Product 4 |  | [NAME] |  |  | 46 |  | 46 |  | 448 |  | 448 |  | 451 |  | 451
 |  |  |  | Product 4 |  | Aluminium |  |  | 386 |  | 386 |  | 432 |  | 432 |  | 406 |  | 406
 |  |  |  | Product 4 |  | [NAME] |  |  | 141 |  | 141 |  | 379 |  | 379 |  | 172 |  | 172
 |  |  |  | Product 4 |  | Aluminium |  |  | 318 |  | 318 |  | 414 |  | 414 |  | 370 |  | 370
 |  |  |  | Product 4 |  | [NAME] |  |  | 485 |  | 485 |  | 248 |  | 248 |  | 169 |  | 169
 |  |  |  | Product 5 |  | Aluminium |  |  | 133 |  | 133 |  | 84 |  | 84 |  | 375 |  | 375
 |  |  |  | Product 5 |  | [NAME] |  |  | 135 |  | 135 |  | 199 |  | 199 |  | 170 |  | 170
 |  |  |  | Product 5 |  | Aluminium |  |  | 466 |  | 466 |  | 453 |  | 453 |  | 58 |  | 58
 |  |  |  | Product 5 |  | [NAME] |  |  | 177 |  | 177 |  | 470 |  | 470 |  | 13 |  | 13
 |  |  |  | Product 5 |  | Aluminium |  |  | 148 |  | 148 |  | 397 |  | 397 |  | 364 |  | 364
 |  |  |  | Product 5 |  | [NAME] |  |  | 13 |  | 13 |  | 480 |  | 480 |  | 491 |  | 491
 |  |  |  | Product 5 |  | Aluminium |  |  | 81 |  | 81 |  | 146 |  | 146 |  | 297 |  | 297
 |  |  |  | Product 5 |  | [NAME] |  |  | 358 |  | 358 |  | 366 |  | 366 |  | 36 |  | 36
 |  |  |  | Product 5 |  | Aluminium |  |  | 429 |  | 429 |  | 267 |  | 267 |  | 369 |  | 369
 |  |  |  | Product 5 |  | [NAME] |  |  | 86 |  | 86 |  | 262 |  | 262 |  | 226 |  | 226
 |  |  |  | Product 6 |  | Aluminium |  |  | 392 |  | 392 |  | 275 |  | 275 |  | 53 |  | 53
 |  |  |  | Product 6 |  | [NAME] |  |  | 488 |  | 488 |  | 271 |  | 271 |  | 399 |  | 399
 |  |  |  | Product 6 |  | Aluminium |  |  | 253 |  | 253 |  | 337 |  | 337 |  | 194 |  | 194
 |  |  |  | Product 6 |  | [NAME] |  |  | 166 |  | 166 |  | 208 |  | 208 |  | 364 |  | 364
 |  |  |  | Product 6 |  | Aluminium |  |  | 40 |  | 40 |  | 231 |  | 231 |  | 298 |  | 298
 |  |  |  | Product 6 |  | [NAME] |  |  | 94 |  | 94 |  | 489 |  | 489 |  | 472 |  | 472
 |  |  |  | Product 6 |  | Aluminium |  |  | 105 |  | 105 |  | 257 |  | 257 |  | 22 |  | 22
 |  |  |  | Product 6 |  | [NAME] |  |  | 91 |  | 91 |  | 321 |  | 321 |  | 163 |  | 163
 |  |  |  | Product 6 |  | Aluminium |  |  | 491 |  | 491 |  | 470 |  | 470 |  | 28 |  | 28
 |  |  |  | Product 6 |  | [NAME] |  |  | 19 |  | 19 |  | 211 |  | 211 |  | 274 |  | 274
 |  |  |  | Product 7 |  | Aluminium |  |  | 382 |  | 382 |  | 254 |  | 254 |  | 479 |  | 479
 |  |  |  | Product 7 |  | [NAME] |  |  | 279 |  | 279 |  | 154 |  | 154 |  | 121 |  | 121
 |  |  |  | Product 7 |  | Aluminium |  |  | 322 |  | 322 |  | 212 |  | 212 |  | 235 |  | 235
 |  |  |  | Product 7 |  | [NAME] |  |  | 261 |  | 261 |  | 349 |  | 349 |  | 445 |  | 445
 |  |  |  |  |  |  |  |  | 16173 | 0 | 16173 |  | 16343 | 0 | 16343 |  | 14952 | 0 | 14952