=AVERAGE(INDIRECT("c"&A2&(":c"&B2)))
On Mon, 2005-10-24 at 22:13 -0600, Jim Martin wrote:
> Hello All:
>
> I am trying to migrate away from ms excel and I was happy that the calc
> in oo2.0 will open my largest spreadsheet. Unfortunately it gives an
> error message regarding a formula that works fine in excel and in
> gnumeric. The formula is something like this:
>
> =AVERAGE(INDIRECT("c"&A2):INDIRECT("c"&b2))
I confess that I didn't know this approach worked in Excel. I have
always built the entire address as a string as at the top of the
message.
>
> where cell a2 and b2 contain integer values that represent the top and
> bottom of a range that I wish to average in column b. I rely on this
> type of forulation heavily in most of my spreadsheets. Calc gives me
> Err:508 which indicates a missing bracket. As you can see, there is no
> bracket error.
> Further, Calc help gives an example of how to use indirect that is
> unlike anthing I have seen in other spreadsheets: =SUM(INDIRECT("a1:" &
> ADDRESS(1;3)))
> I assume that this syntax would work with average too. Even so, it seems
> very different to the way I am used to using indirect. I can't see how I
> could apply this to my common usage of specifying row and colum values
> to other fucntions via indirect. For instance, I would not know in
> advacne that I needed to start averaging at cell a1 (as in the example)
> nor would I know how many rows or columns I would need to average. I
> relay on match and row functions to give me those values.
>
> So, looks like I won't be an OpenOffice user unless one or you can tell
> me how to make my style of equation work in Calc. Anybody?
>
> Thanks in advance,
>
> Jim
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
Ian Laurenson <[EMAIL PROTECTED]>
Hillview
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
