Thanks for your pacience. I'll work with this options and look where I'll get.
> 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 -- _________________________________________________________________________ Claudia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
