You have an inquiring mind and your question makes me think.
=SUM(A3) is the same as =A3. If the value (however derived) of A3 is 2,
then the value in A4 will also be 2.
=OFFSET provides no summation; it is designed to provide the value of a
single cell. Combining it with SUM enables it to provide the value of a
range of cells.
As for similar situations, perhaps the function SUMIF is such a case.
It is not so obvious because it is expressed as one function but it
could be said to be derived from two other functions - SUM and IF.
Similarly, SUM(OFFSET, we could say, is a composite function.
Claudia Drechsle wrote:
So the formula submits to a function a different value than the one you get
directly, is it that?
When you write in A3: =OFFSET(A1;1;0;1;$A$1)
And in A4: =SUM(A3)
That will never be the same than =SUM(OFFSET(A1;1;0;1;$A$1))
Are there more cases like this?
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
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]
