out of sequence reference
 

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

out of sequence reference
 

=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

out of sequence reference
 

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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497175