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 -- _________________________________________________________________________ Claudia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
