I'm offset by the Offset Function

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

Date: Tue, 17 Aug 2004 03:04:25 +0530

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: Im offset by the Offset Function
    ... Does this mean that if we specify a "reference" in the first argument then ... 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 ... Regards, ...
    (microsoft.public.excel.misc)
  • Re: How do I return last cell from a row of data?
    ... If the data is continuous (ie no empty cells in between ... >cell in a row of data, that is the last cell with data. ... >to specify a cell address that defines a base cell then ... >number then a cell with the offset, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I return last cell from a row of data?
    ... > If the data is continuous (ie no empty cells in between ... >>cell in a row of data, that is the last cell with data. ... >>to specify a cell address that defines a base cell then ... >>number then a cell with the offset, ...
    (microsoft.public.excel.worksheet.functions)
  • How do I return last cell from a row of data?
    ... I'm wanting to do a fairly simple calculation that needs to use the last ... cell in a row of data, that is the last cell with data. ... to specify a cell address that defines a base cell then the offset of the ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Lookup
    ... We use Offset to ... Cell A5 = 11 ... value in the header row 100 down to 1 ... known as the Upper Quality Limit and that is mathmatically calculated in cell ...
    (microsoft.public.excel.programming)
Loading