Spreadsheet: 885326d1734817122-sumproduct-of-every-nth-column-changing-every-9-columns-forms-mocked-up-results-without-sensitive
Sheet: DATA

 | MOCKED UP RESULTS IF POSITIFS VALUES IN T COLUMN
 |  |  |  |  |  |  |  |  |  | the value of BL20 and BU20 dependent on the vaalue in BL18 and BU 18 IF BL20 and BU20 are < 0 the result in D20 is correct cause the formula calculate the difference between a positive and negative value  for example if [NAME] and BU18=2 then we have the sum of -9,400 and -6,249= -15,649 from which we do the substraction of 4,351 (3,751+0,600) = -11,30 in D20 which is ok  if ever the value in BL20 and/or BU20 and/or the other cells till the end is positve the formula doesn't consider the positive value but only the negative. So if  [NAME] and BU18=40 we have 3,751+12 = 15,751 and -6,249. So I need to make him understand that he has to consider the positive value as a additional quantity and then we'll have -4,249 in G20 (-6,249+2). so the result in D20 will be correct
 | DEPENDING ON THE VALUES IN T18 and K18
 |  | 3 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE
 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  | 40
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51 | Column52 | Column53 | Column54 | Column55 | Column56 | Column57 | Column58 | Column59 | Column60 | Column61 | Column62 | Column63 | Column64 | Column65 | Column66 | Column67 | Column68 | Column69 | Column70 | Column71 | Column72 | Column73 | Column74 | Column75 | Column76 | Column77 | Column78 | Column79 | Column80 | Column81 | Column82
 | SAMPLE 1 |  |  |  |  |  | 10 | 17.05 |  |  | 17.05 |  |  | 17.05 |  |  | 30 |  |  | 16.79 |  |  | 16.79
 | SAMPLE 2 |  |  |  |  |  | 0.1 | 0.14 |  |  | 0.14 |  |  | 0.14 |  |  | 0.45 |  |  | 0.45 |  |  | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 |  |  | 0.02 |  |  | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03 |  |  | 0.03 |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04 |  |  | 0.04 |  |  | 0.04
 | EXPECTED RESULT |  |  |  |  |  |  | 0.11 |  |  | 0.11 |  |  | 0.11 |  |  | 0.16 |  |  | 0.16 |  |  | 0.16
 | SAMPLE 1 |  |  |  | -4.249 | 15.751 | 10 | 17.05 |  |  | 0.12 |  |  | 0.12 |  |  | 30 |  |  | 0.28 |  |  | 0.28
 | SAMPLE 2 |  |  |  | 0.011 | 0.211 | 0.1 | 0.14 |  |  |  |  |  |  |  |  | 0.45 |  |  | 0.28 |  |  | 0.28
 |  |  |  |  |  |  |  | 0.24 |  |  | 0.24 |  |  | 0.24 |  |  | 0.3 |  |  | 0.3 |  |  | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.67 |  |  | 0.67 |  |  | 0.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.69 |  |  | 0.69 |  |  | 0.69
 |  |  |  |  |  |  |  | 0.9 |  |  | 0.9 |  |  | 0.9 |  |  | 0.95 |  |  | 0.95 |  |  | 0.95
 |  |  |  |  |  |  |  | 1.39 |  |  | 1.39 |  |  | 1.39 |  |  | 1.64 |  |  | 1.64 |  |  | 1.64
 |  |  |  |  |  |  |  | 1.57 |  |  | 1.57 |  |  | 1.57 |  |  | 1.79 |  |  | 1.79 |  |  | 1.79
 |  |  |  |  |  |  |  | 2.3 |  |  | 2.3 |  |  | 2.3 |  |  | 2.14 |  |  | 2.14 |  |  | 2.14
 |  |  |  |  |  |  |  | 73.34 |  |  | 73.34 |  |  | 73.34 |  |  | 72.23 |  |  | 72.23 |  |  | 72.23
 |  |  |  |  |  |  |  | 0.05 |  |  | 0.05 |  |  | 0.05