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...