Offset Formula Help

[CROY1985]

Hi all.

I have a spreadsheet with the following cascade formula:

 

[ukmikeb]

Hi

Try wrapping the formula in code tags - # just above msg area.

hth

 

[CROY1985]

Hi

Sorry it didn't post in full before.

I have a set of cascading figures which are driven by an offset formula. Here is the example: https://picasaweb.google.com/croy1985/Excel#5647687400779447330

What i need is a sum which adds all of the figures which are dependent on year 1, year 2, year 3 etc. To help, i have highlighted year 1 figures in yellow, year 2 figures in green, and year 3 in orange.

Each year always has 13 periods.

On a monthly basis, i need to know how many are from year 1, year 2, year 3 etc.

Hope you can help with this.

Thank you.

 

[ukmikeb]

Hi

I have reported this as duplicate of -
http://www.mrexcel.com/forum/showthread.php?t=576191

which means the Mods are likely to close this thread.

Anyway you have more information in the other thread.

Hope that's ok.

 

[VoG]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).