formula patterns when copying down groups

[Chezterfield]

Hi All,

I have the below formula which I want to copy down to the next cells with a pattern on 3 so that

=SUM(D13,D49,D85,D121,D157,D193,D229,D265,D301,D337,D373,D409,D445,D481,D517)

becomes

=SUM(D16,D52,D88,D124,D160,D196,D232,D268,D304,D340,D376,D412,D448,D484,D520)

Is this possible, perhaps we need to use offset function?

Any help would be great appreciated.

[NBVC]

Try this:

Create a Named formula, by going to Insert|Name|Define.

Call it "Range" (without quotes) and use formula:

Please Login or Register  to view this content.

where 1000 defines the furthest down you will need to sum in range column D.

then apply formula in spreadsheet:

Please Login or Register  to view this content.

Confirmed with CTRL+SHIFT+ENTER not just ENTER and then copy down.