Sum every nth column in sp

[freshtomm]

Hi guys,

i need to sum every eight column in variable row number. For example i need to sum every eight column in row 29. The number of row must be used in the formula. Could somebody help me with this formula?

Thanks

 

[Naresh Yadav]

can we have some part of your data along with your desire result?

 

[Khalid NGO]

Hi,

Try something like:
=SUMPRODUCT((MOD(COLUMN($A$1:$Z$1),8)=0)*A29:Z29)

adjust A:Z to suite.

Regards,

 

[freshtomm]

Here it is, i need to sum all Zaplaceno columns (Zaplaceno 1, Zaplaceno 2, Zaplaceno 3...), but only in row with date 31.5.2015 for example.

 

[Khalid NGO]

i need to sum all Zaplaceno columns (Zaplaceno 1, Zaplaceno 2, Zaplaceno 3...),

This is completely different question

Try this in EX6:
=SUMIF(B$1:EW$1,"Zaplaceno*",B6:EW6)

Copy down

but only in row with date 31.5.2015 for example.

Not clear to me.

Regards,

 

[Naresh Yadav]

"Dear Freshtomm,

pls remove your heading Zaplaceno 1 ,Zaplaceno 2,Zaplaceno...so on in to "Zaplaceno" and than use below formula which needs to be finished with CTRL+SHIFT+ENTER
=SUM(IFERROR((D1:EW1=D1)*D2:EV31,"")) (formula highlighted in Red color)
pls referred to the attached file for better understand

 

[freshtomm]

Thank you.