Rogier van Vlissingen wrote:
Well, you got me experimenting, but this isn't it yet, but I did some
editing to clarify the problem:
...
On Sun, 11 Jan 2009 16:29:31 -0500, Erik Remmelzwaal
...
I assume that your lookups return both corner coordinates of the array
as a string like "B2" and "C5"
You can than write a formula like:
=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))
For a sample sheet, see
http://www.martnet.com/~jes/temp/range_select_example.ods
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
