Spreadsheet: 145507d1331627484-sumproduct-range-of-cells-selling-price-test
Sheet: Sheet1

MATERIAL | RAW/RAW
DESIGN | 18 3D |  |  |  |  |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE
FINISH | NORMAL |  |  |  |  |  |  |  |  |  |  |  |  |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAW/RAW |  |  |  |  | RAW/RAW |  |  |  |  | RAW/RAW |  |  |  |  | RAW/RAW |  |  |  |  | RAW/WHITE |  |  |  |  | RAW/WHITE |  |  |  |  | RAW/WHITE |  |  |  |  | RAW/WHITE |  |  |  |  | WHITE/WHITE |  |  |  |  | WHITE/WHITE |  |  |  |  | WHITE/WHITE |  |  |  |  | WHITE/WHITE
DIMENSIONS |  |  | 18mm |  |  |  |  | 25mm |  |  |  | TOTAL | TOTAL |  | 18 3D |  |  |  |  | 18 2D |  |  |  |  | 25 3D |  |  |  |  | 25 2D |  |  |  |  | 18 3D |  |  |  |  | 18 2D |  |  |  |  | 25 3D |  |  |  |  | 25 2D |  |  |  |  | 18 3D |  |  |  |  | 18 2D |  |  |  |  | 25 3D |  |  |  |  | 25 2D
W | H | D | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | 18mm | 25mm | NORMAL |  |  |  |  | NORMAL |  |  |  |  | NORMAL |  |  |  |  | NORMAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL |  |  |  |  | SPECIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | €
400 | 700 | 550 | 1 |  |  |  |  |  |  |  |  |  | #N/A |  | 10 | 12 | 14 | 16 |  | 12 | 14 | 16 | 18 |  | 15 | 17 | 19 | 21 |  | 18 | 20 | 22 | 24 |  | 22 | 24 | 26 | 28 |  | 25 | 27 | 29 | 31 |  | 30 | 32 | 34 | 36 |  | 35 | 37 | 39 | 41 |  | 40 | 42 | 44 | 46 |  | 45 | 47 | 49 | 51 |  | 50 | 52 | 54 | 56 |  | 52 | 54 | 56 | 58
450 | 700 | 550 |  |  |  |  |  |  |  |  |  |  |  | 0 | 12 | 14 | 16 | 18 |  | 14 | 16 | 18 | 20 |  | 17 | 19 | 21 | 23 |  | 20 | 22 | 24 | 26 |  | 24 | 26 | 28 | 30 |  | 27 | 29 | 31 | 33 |  | 32 | 34 | 36 | 38 |  | 37 | 39 | 41 | 43 |  | 42 | 44 | 46 | 48 |  | 47 | 49 | 51 | 53 |  | 52 | 54 | 56 | 58 |  | 54 | 56 | 58 | 60
500 | 700 | 550 |  |  |  |  |  |  |  |  |  |  |  | 0 | 14 | 16 | 18 | 20 |  | 16 | 18 | 20 | 22 |  | 19 | 21 | 23 | 25 |  | 22 | 24 | 26 | 28 |  | 26 | 28 | 30 | 32 |  | 29 | 31 | 33 | 35 |  | 34 | 36 | 38 | 40 |  | 39 | 41 | 43 | 45 |  | 44 | 46 | 48 | 50 |  | 49 | 51 | 53 | 55 |  | 54 | 56 | 58 | 60 |  | 56 | 58 | 60 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  | ANSWER IN CELL N9 SHOULD READ 10
 |  |  |  |  |  |  |  |  |  |  |  |  | THE FORMULA I NEED IS TO GIVE ME THE SUMPRODUCT OF SAY 18mm x PRICE ACCORDING TO MATERIAL AND DESIGN AND FINISH.
 |  |  |  |  | TOTAL ROWS ARE ABOUT 2000