2009/1/12 Joe Smith <[email protected] > > >> On Sun, 11 Jan 2009 16:29:31 -0500, Erik Remmelzwaal >> >>> ... >>> =AVERAGE(INDIRECT("B2:C5")) >>> ... >>> >> > I prefer to avoid constructing an address or range through INDIRECT unless > absolutely necessary. There are too many ways for it to break, in part > because the addresses in such formulas are not adjusted if things get moved > around. > > In most cases, the OFFSET function can be used instead, and it uses only > normal references. > > If I understand what Rogier is after, this case can be handled with a > formula something like this: > =AVERAGE(OFFSET(Data_Table; Row_Offset; Col_Offset; 1; > End_Period-Start_Period+1))
Hi Joe, this much more elegant completely overlooked,! Thanks for pointing this out. Erik
