Sum each 9th Row?

[kdowning]

I am trying to make a formula in cell D22 that will add D23 + D32 + D41 + D50 + ect. I found a thread that explained how to do this I though but when I modified to formula I couldn't get it to work properly.

Original Thread (https://www.mrexcel.com/forum/excel-questions/621629-sum-every-nth-row.html)
=SUMPRODUCT($D$10:$D$249*(MOD(ROW($D$10:$D$249),3)=1))

Modified Formula
=SUMPRODUCT($D$23:$D$688*(MOD(ROW($D$23:$D$688),9)=1))

Any help would be appreciated.

Kenny

 

[JoeMo]

Try:

=SUMPRODUCT($D$23:$D$688*(MOD(ROW($D$23:$D$688),9)=5))

 

[mrhstn]

If you do =MOD(23, 9) you will see it returns 5, so by logic try...

=SUMPRODUCT($D$23:$D$688*(MOD(ROW($D$23:$D$688),9)=5))

 

[kdowning]

Thanks everyone, I didn't understand this formula but now have it figured out thanks to your help.