SUMPRODUCT+MOD+COLUMN in n+ column

[stefangeorgi]

Hi everyone,
I have the following problem. I have 3 identicals columns which repeats (image 1)
I would like to tell excel to calculate the values in the green column for every green column after that. But the problem here is that the starting point change so the number of the column too.
I have this formula that works

SUMPRODUCT(--(MOD(COLUMN(AD8:LM8)-COLUMN(AD8)+1;9)=0);--(AD8:LM8>0);-(ISFORMULA(AD8:LM8));AD8:LM8)

considering positive or negative values
and tried this on in order to resolve the issues I have but it doesn't work :

SUMPRODUCT(--(MOD(COLUMN(AD8:INDEX(AD8:LM8;COLUMN()-1))-COLUMN(AD8)+1;3)=0)+0;--(AD8:LM8<0);-(ISFORMULA(AD8:LM8));AD8:INDEX(AD8:LM8;COLUMN()-1))

if someone could tell me where I have to put the index function and how?
thank you !

 

[awoohaw]

Can you install the xl2bb add in (link is below) and post a mini workbook of your worksheet(s). In order for the forum to start on this they have to manally create your data. And typing errors can occur. Plus the image may not be easy to read for some people. Thanks in advance!