Re: I'm offset by the Offset Function

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 23:42:41 +0200

Hi
your formula is valid but in the first case you could either write it
as:
=SUM(OFFSET(C3,-1,0,3,3))

or
=SUM(OFFSET(C3:E5,-1,0)) 

--
Regards
Frank Kabel
Frankfurt, Germany
"Hari" <excel_hari@hotmail.com> schrieb im Newsbeitrag
news:#g3HPj9gEHA.3632@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> In the Excel's help Offset function is explained in the 2nd Example
as
>
> =SUM(OFFSET(C3:E5,-1,0,3,3)) will give a result of "Sums the range
C2:E4"
>
> My doubt is would it matter if we specify the first argument as C3:E5
or C3
> only.
>
> As per my perfunctory reading thru help it seemed that even if I
write
> =SUM(OFFSET(C3,-1,0,3,3)) we should get the result as "Sums the range
C2:E4"
> (As per my understanding fourth and fifth arguments "Height" and
"Width"
> shud take care of the required range. Shouldnt it?)
>
> Also if the above is true then why is it listed in the first argument
> description that it is "Reference must refer to a cell or range of
adjacent
> cells"
>
> Hence, my question is how would the results of Offset change when our
first
> argument is a cell and on the other case argument is a range of
adjacent
> cells?
>
> Regards,
> Hari
> India
>
> PS:  It seems Microsoft's help is missing the example data for the
offset
> function in Excel 2002
>
>