Re: I'm offset by the Offset Function

From: Hari (excel_hari_at_hotmail.com)
Date: 08/16/04 

Date: Tue, 17 Aug 2004 04:23:56 +0530

Hi Frank,

Does this mean that if we specify a "reference" in the first argument then
we neednt specify the 4th and the 5th argument (or they may be zero and
zero) which are height and width? If so why has MS given a "confusing"
example in help. I mean is there anything behind it.

Also suppose we specify a single cell in 1st argument then we need to
specify the 4th and 5th as non zero in case we want the final offset answer
to be a range?

Regards,
Hari
India

"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:OdfaWn9gEHA.4092@TK2MSFTNGP10.phx.gbl...
> 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
> >
> >
>

Relevant Pages

  • Re: Entry of Incomplete Dates
    ... I suppose my only solution is to check every cell ... >> I am attempting to extract data from a series of dated reports, ... Is there any way to specify a default year when the date is ...
    (microsoft.public.excel.programming)
  • Re: ASP.NET Images are not displayed
    ... Richard Hein ... >>and img tag. ... > Would you please tell me how do you specify the picture's location in your ... > Best regards, ...
    (microsoft.public.vsnet.ide)
  • Im offset by the Offset Function
    ... In the Excel's help Offset function is explained in the 2nd Example as ... My doubt is would it matter if we specify the first argument as C3:E5 or C3 ... description that it is "Reference must refer to a cell or range of adjacent ... my question is how would the results of Offset change when our first ...
    (microsoft.public.excel.misc)
  • RE: Filling Text from Another File
    ... you are using because you didn't specify (I don't think, atleast): ... Dave ... >> Regards, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Allen: TechQ
    ... > specify a writeable drive, like C:, for the changed version. ... > regards, Fred ... guess I am getting back into the UNIX era. ... that is why I miss the o/s I ...
    (misc.news.internet.discuss)