Is there an indirect index in Gnumeric?

[E K]

Some years back (in the era of Lotus-123) I had  similar problem which I solved with a macro. Basically, what I did was move the cursor from a fixed cell position in some direction a distance specified in the control cell, define a range of highlighted cells. Use the range name in the required formula.I am not sure if gnumeric can do that.
EK
--- On Mon, 7/21/08, Christopher Browne <cbbrowne-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org> wrote:
From: Christopher Browne <cbbrowne-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org>
Subject: Re: [TLUG]: Is there an indirect index in Gnumeric?
To: tlug-lxSQFCZeNF4 at public.gmane.org
Received: Monday, July 21, 2008, 11:05 AM

On Mon, Jul 21, 2008 at 2:30 AM, Walter Dnes <waltdnes-SLHPyeZ9y/tg9hUCZPvPmw at public.gmane.org>
wrote:
>  Situation...
>  - spreadsheet cell A1 has value 25
>  - cell A2 has value 35
>
>  Is there a way to read those cells and use their values as indexes?
> E.g. suppose I want to take =average(C25:C35), without literally writing
> the values, by obtaining the range from the values in cells A1 and A2.

There is a LOOKUP function that allows you to search for values within
a range.  Unfortunately, that doesn't get you an average across a
specified range :-(.

Spreadsheets don't give this much of a degree of indirection :-(.

It wouldn't be difficult to have a function to express this; you'd
essentially define an AVERAGE function that has 4 parameters
indicating the 4 corners of the rectangle.  But it's not something
that is supported in any spreadsheet I know of.
-- 
http://linuxfinances.info/info/linuxdistributions.html
"The definition of insanity is doing the same thing over and over and
expecting different results." -- assortedly attributed to Albert
Einstein, Benjamin Franklin, Rita Mae Brown, and Rudyard Kipling
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists


      __________________________________________________________________
Ask a question on any topic and get answers from real people. Go to Yahoo! Answers and share what you know at http://ca.answers.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/legacy/attachments/20080722/99bd9126/attachment.html>