=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)


"Addy" wrote in message
...
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