How To Put One OFFSET Function In Another?

[-Doug-]

Hello,

I am using "Defined Names" to generate dynamic graphs for a project I am working on.
Currently I am trying to graph quarterly data automatically. In order to do so I am setting up a series of "Defined Names" with OFFSET functions.

I have a column of data that is currently being calculated from another sheet using =SUM(OFFSET(B$3,(ROW()-ROW($B$3))*3,0,3,1))
Another column extracts all the first quarter data of the previously mentioned column using =OFFSET($E$3,ROWS($1:1)*4-4,)

In addition to these I have been using a "defined name" to automatically update other charts =OFFSET('Flows and Data'!$A$3,0,0,COUNTA('Flows and Data'!$A:$A)-1)

I was wondering if anyone knew how to embed =OFFSET($E$3,ROWS($1:1)*4-4,) into =OFFSET('Flows and Data'!$A$3,0,0,COUNTA('Flows and Data'!$A:$A)-1) and have it work?

Can you put an offset function into another?

Any Help would be appreciated,

Doug

[Pete_UK]

OFFSET is a volatile function, so I don't think you can combine them like that. You might think about using INDEX, which is not volatile, and you can get the same functionality with it.

Hope this helps.

Pete