sum on every 17th column

[andrewb90]

Hello all,

I found this formula online, and It's just not quite working as intended.

=SUMPRODUCT((MOD(COLUMN($D4:$II4),17)=0)*($D4:$II4))

I'm wanting it to cum the value of every 17th cell, however when I change it to 17 it counts the 17th column first(q) then every 17, But I'm wanting the first column D counted then every 17th from there. How do I modify this?

 

[snjpverma]

=sumproduct((mod(column($d4:$ii4),16)=4)*$d4:$ii4)

 

[ricardov]

16... I feel dumb now. thanks!

No need to feel dumb. It can be 17 depending on how you look at it and your starting point
You're all good man. Cheers!