software

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

=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)quot;Addyquot; gt; wrote in message
...
gt;I am using a formula
gt;
gt; =SUM('DE Dec'!D9:AS9)
gt;
gt; i want it to increase in the next row as
gt;
gt; =SUM('DE Dec'!D14:AS14)
gt; =SUM('DE Dec'!D19:AS19)
gt; and so on.... in an Arithmetic Progression, is it possible
There might be an easier way but try this:

=SUM(INDIRECT(quot;'DE
Dec'!Dquot;amp;9 ((ROW(1:1)-1)*5)amp;quot;:ASquot;amp;9 ((ROW(1:1)-1)*5)))

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497175