out of sequence reference

A

Addy

I am using a formula

=SUM('DE Dec'!D9:AS9)

i want it to increase in the next row as

=SUM('DE Dec'!D14:AS14)
=SUM('DE Dec'!D19:AS19)
and so on.... in an Arithmetic Progression, is it possible
 
P

Peo Sjoblom

=SUM(OFFSET('DE DEC'!$D$9,ROW(1:1)*5-5,,,COLUMNS('DE DEC'!$D$9:$AS$9)))

or

=SUM(INDEX($D$9:$D$10000,1+ROW(1:1)*5-5):INDEX($AS$9:$AS$10000,1+ROW(1:1)*5-5))

copy down

--
Regards,

Peo Sjoblom

(No private emails please)
 
P

pinmaster

There might be an easier way but try this:

=SUM(INDIRECT("'DE
Dec'!D"&9+((ROW(1:1)-1)*5)&":AS"&9+((ROW(1:1)-1)*5)))

HTH
JG
 
Top