Formual to Add data every nth row

[rizmomin]

Hello:

I have bunch of column Data in Column D:H

My data starts in row 5.
I need a excel formula to add data every 63rd row for column D:H.

So for example for column D, i would have D5+D67+D129 and so on until D687

Let me Know if you have any questions.
Thanks.

Riz

[Olly]

I'm not clear. Do you just want:

Please Login or Register  to view this content.

[rizmomin]

Hello Olly:

Yes this is how i want it, but is there a simple formula instead of defining all cells.

Riz

[cffndncr]

Umm... I'm not an expert, but wouldn't it just be

=SUM(D5,D67,D129,D191,D253,D315,D377,D439,D501,D563,D625,D687)

[martindwilson]

if you must
=SUMPRODUCT((D5:D687)*(MOD(ROW(D5:D687),62)=5))

[rizmomin]

Hello:

Below is the example of how to add every 4th column:

Please Login or Register  to view this content.

So i wonder if there is such a formula to add every nth row

Let me Know if you have any questions.
Thanks.

Riz

[Olly]

Try:

Please Login or Register  to view this content.

Use as:

Please Login or Register  to view this content.

[martindwilson]

see post #5

[rizmomin]

Hello:

I got it working with following formula:

Please Login or Register  to view this content.

Once again, thanks to all for help

Riz