It's a new day and I'm more widely awake (I hope). It seems to me that
the explanation is fairly simple.
=OFFSET(A1;1;0;1;$A$1) equates to =A2
=SUM(OFFSET(A1;1;0;1;$A$1)) equates to =SUM(A2:C2)
=SUM(A3) equates to =A3
Ross Johnson wrote:
<snip>
The description in Help says that it "returns the value of a cell", but
this is not correct, as the Function Wizard correctly says, it returns a
reference (to a range - which can one or more cells of course).
In the case of =OFFSET(...), the returned reference is (re)evaluated to
return the cell value, and in the case of =SUM(OFFSET(...)) it is
evaluated by the SUM() function.
<snip>
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]
