autofill from other sheet with 11 row interval

[tcy1227]

Hi All,

I am having a bit of an issue with fill series.

I need to change the interval that the fill series uses.

I have a sheet called: Loan Amortization Schedule1 (referred to here as "LAS1")

I am trying to fill values in Sheet 1 for the yearly payments made to the mortgage loan, SO
- values in the column of Sheet 1 should be filled from LAS1 column G at 11 row intervals. (i.e. I start with G18 - G29, next row in Sheet 1 should be G30 - G41, etc...)

Right now, my cell in Sheet1 for first year payments is: =SUM('Loan Amortization Schedule1'!G18:G29)

I want to autofill this but when I drag down the autofill only adds 1 to each value (so changes to G19:G30, G20:G31 and so on).

I have tried manually entering 3 cells (G18:G29, G30:G41, G42:G53) and autofilling, but excel is coming up with very random starting values to use, and THEN doing it by 11 rows intervals.

Any help would be greatly appreciated.

Thanks

[DBY]

Hello
If for example, your column in sheet LAS1 runs from G18:G118, then the following formula run down say sheet1, should return a sum of every group of 12 cells. ie G18:G29; G30:G41 etc.

Please Login or Register  to view this content.

Hope this helps.
DBY