Hi all, Im wondering if it is possible to autofill something like this:


(C34) =IF($B$6=B34;0;SUMPRODUCT($D$2:INDEX($D$2:$D$31;$B$6-B34);$E$2:INDEX($E$2:$E$31;$B$6-B34)))
(C35) =IF($B$6=B35;0;SUMPRODUCT($D$2:INDEX($D$2:$D$31;$B$6-B35);$F$2:INDEX($F$2:$F$31;$B$6-B35)))
(C36) =IF($B$6=B36;0;SUMPRODUCT($D$2:INDEX($D$2:$D$31;$B$6-B36);$G$2:INDEX($G$2:$G$31;$B$6-B36)))


every next column needs a data figure from the next row. So I have to change by hand the columnnumber in each row.
transposing the thing wont matter cuz then somewhere else will be the same problem.
Is there a way to do this cuz the dollarsign method lacks the solution.

(ColomnE) (columnF) (ColumnG)
nqx+1 nqx+2 nqx+3
0,00119119 0,001299109 0,001417813
0,001297561 0,001415972 0,001546225
0,001414285 0,001544216 0,001686846



Tnx, Goofer