Spreadsheet: 484890d1476543388-complicated-product-of-multiple-cells-wl
Sheet: Blad1

 |  |  | How it looks without the formula
 | Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet Board and Calculator
 | Warm Up + Snatch Complex |  |  |  |  |  |  | Work Load |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 kg |  |  | 40 kg |  | 45 kg |  | 50 kg |  | 55 kg
 | Snatch |  |  |  | 4 x 3 | 3x3 | 2 x 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 kg |  |  | 100 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 kg | 85 kg | 93 kg | 98 kg | 100 kg | 105 kg | 108 kg | 113 kg | 115 kg | 123 kg
 | Snatch Strict Press |  |  |  | 2 x 7 | 2 x 5 | 2 x 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 cm |  |  | 105 cm |  | 110 cm |  | 115 cm |  | 122 cm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 kg |  |  | 33 kg
 | Snatch Grip Upright Row |  |  |  |  | 2 x 7 | 1 x 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #1 |  |  |  |  | #1.5 |  |  |  | #2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 kg | 65 kg | 75 kg | 85 kg | 100 kg
 | Romanian Deadlift |  |  |  |  | 2 x 10 | 12x3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 kg | 65 kg | 75 kg | 85 kg | 95 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 kg | 65 kg | 75 kg | 85 kg | 95 kg
 | Cool Down |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 kg | 150 kg | 160 kg | 170 kg | 180 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160 kg | 165 kg | 170 kg | 175 kg | 180 kg | 190 kg | 200 kg
 |  |  | What I want the formula to do |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 kg | 65 kg | 70 kg | 75 kg | 80 kg | 85 kg | 90 kg
 | Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 kg |  | 65 kg |  | 70 kg |  | 73 kg | 75 kg | 80 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 kg |  |  | 30 kg |  | 35 kg |  | 40 kg |  | 50 kg
 | Warm Up + Snatch Complex |  |  |  |  |  |  | Work Load |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 kg |  |  | 40 kg |  | 50 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 kg | 50 kg | 55 kg | 60 kg | 65 kg
 | Snatch |  |  |  | 4 x 3 | 3 x 3 | 2 x 3 | 27 | [NAME] This cell should be the product of the total rep amount of the three cells to the left of it. Btw, is "4 x 3" a valid format for multiplication in excel or is another format necessary? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 kg |  |  | 18 kg
 |  |  |  |  |  |  |  | 1 077 kg | [NAME] This cell should be the product (with round of) of the weight*total rep amount of the three cells to the left of it. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 kg |  | 45 kg |  | 50 kg
 | Snatch Strict Press |  |  |  | 2 x 7 | 2 x 5 | 2 x 5 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 kg | 105 kg | 110 kg | 115 kg | 120 kg | 125 kg | 120 kg | 135 kg | 140 kg | 150 kg
 |  |  |  |  |  |  |  | 822 kg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 kg | 90 kg | 95 kg | 100 kg | 105 kg | 110 kg | 115 kg | 120 kg | 125 kg | 130 kg
 | Snatch Grip Upright Row |  |  |  |  | 2 x 7 | 1 x 5 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 kg |  | 100 kg
 |  |  |  |  |  |  |  | 548 kg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 kg | 70 kg | 75 kg | 85 kg | 100 kg
 | Romanian Deadlift |  |  |  |  | 2 x 10 | 1 x 7 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 kg |  |  | 110 kg |  | 130 kg |  | 150 kg
 |  |  |  |  |  |  |  | 1 885 kg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 kg
 | Cool Down |  |  |  |  |  |  | 119 | [NAME] This cell should be the product of the total rep amount of the four "total rep amount" cells above it. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 kg
 |  |  |  |  |  |  |  | 4 332 kg | [NAME] This cell should be the product of the total weight amount of the four "total weight amount" cells above it. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 kg | 55 kg | 60 kg | 65 kg | 73 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 kg |  |  | 40 kg |  | 50 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 kg | 80 kg | 90 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 kg | 110 kg | 120 kg | 130 kg | 140 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 kg | 45 kg | 50 kg | 55 kg | 60 kg | 65 kg | 70 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 kg | 35 kg | 40 kg |  | 45 kg | 50 kg | 53 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 kg |  | 130 kg |  | 150 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 kg | 0 kg | 5 kg |  | 10 kg |  | 15 kg |  | 20 kg |  | 25 kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 kg | 0 kg | 0 kg | 0 kg | 0 kg | 5 kg | 10 kg | 15 kg | 20 kg | 25 kg | 30 kg | 35 kg | 40 kg | 45 kg | 50 kg
 |  |  |  |  |  |  |  | 17 x 234