The formula =OFFSET(A1;1;0;1;$A$1) is returning the value of the first
cell in the range. The result would be the same if you omitted the last
two parameters. The first parameter is the name of the cell from which
the offset is taken. The next adds one row and the next adds zero
columns. The fourth parameter is the number of rows and the last is the
number of columns.
Claudia Drechsle wrote:
Hi Terry wrote:
Try this: =SUM(OFFSET(A1;1;0;1;$A$1))
I never saw the function offset in this use, that opens new views for me,
its great.
But I do not really understand it.
When I write the function OFFSET(A1;1;0;1;$A$1) alone, it provides a value,
in the actual example it's allways 2.
But SUM(2) would not be, what we look for.
I see, that your formula works, but I don't know why.
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
