Re: Index ( )

JMB,

I better clarify. When I said: My vote is the former. I meant it is wrong
to print C1:C6.

Sounds like you agree with me and we have two votes. But you haven't
explicitly stated that it is wrong to print C1:C6. Wonder if you caught
that and **truly understood** what I was trying to point out.

Epinn

"JMB" <JMB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E6DFEF0-93BC-49A7-8705-AB102CA1773A@xxxxxxxxxxxxxxxx
The range A1:C11 is comprised of one area, not two. A space in the data
does
not divide it into two areas. The example formula in help is properly
summing C1:C11, which is 216.


"Epinn" wrote:

Please refer to the INDEX () in Help.

(1) Please scroll down and take a look at the third example of
Reference
form.

=SUM(INDEX(A1:C11,0,3,1))

I don't agree with the following description (result) beside the above
formula.

"The sum of the third column in the first area of the range A1:C11,
which is
the sum of C1:C6. (216)"

Please note that the sum of C1:C6 is NOT 216. So, either C1:C6 is wrong
OR
216 is wrong.

My vote is the former. In my opinion, the first area of the range
A1:C11 is
A1:C11 based on the formula, although row #7 is blank. If we only want
the
third column, then we should look at C1:C11. The sum of C1:C11 **is**
216.

Please let me know what the right version should be. Either way MS
needs to
fix the above description.

(2) Please compare the following:-

First example of array form =INDEX(A2:B3,2,2) and

First example of reference form =INDEX(A2:C6,2,3)

Just looking at the formulas I don't see any difference in the format
and I
won't be able to tell that one is array form and one is reference form.
Also, they both return a value. What is Help trying to tell me?

(3) Array vs. Reference

As far as I am concerned, an array is a reference. A1:A6 is an array
and is
also a reference. However, A1 is NOT an array but is a reference. I am
quite confused about these two terms as Help puts it and the fact that
INDEX() is categorized into array form and reference form. Comments
welcome.

Appreciate help in sorting out the above.

Epinn





.

Relevant Pages

  • Re: Index ( )
    ... "The sum of the third column in the first area of the range A1:C11, ... Array vs. Reference ... INDEXis categorized into array form and reference form. ...
    (microsoft.public.excel.newusers)
  • Re: Count the times a value appears in a column based on another v
    ... The array form of this formula is requires the original notation, ... Note also, that it is shorter, but in general SUMPRODUCT ... The COUNTIF function works each time to find the right ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Using VLOOKUP to locate an answer in one of multiple columns
    ... Please rate this post using the vote buttons if it was helpful. ... "ksean" wrote: ... Do you have any ideas what I am missing? ... When you do a look up, you are looking up a value in an array, so if the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: search for a specific word and copy the word and the preceeding words until a comma
    ... there is no need of array form in the examples given. ... This behavior is similar to standard Excel functions. ... Furthermore, if you require a horizontal array, change the array constant to ...
    (microsoft.public.excel.programming)
  • Re: array of booleans
    ... > however, when no NUMERIC vote is entered, i want to be able to default ... Don't i need to store it in an array? ... > nter or eset ballot paper: ... in pseudo code: ...
    (comp.lang.java.programmer)