SUM of INDEX as array formula

[CJEJung]

Hi all,

I am trying to use the following array formula:

{=SUM(INDEX(range,{1,2},1))}

It does not work. The range just returns the sum of the first cell returned by the index, ie SUM(INDEX(range,1,1)).


Let me explain what I want to do: I have a certain range from which I want to extract two numbers and then take the sum of them. These numbers are the ones in position {1,1} and {2,1} of the range in question.

When I write the inner formula into two adjacent cells as an array formula, ie, {=INDEX(range,{1,2},1)} in cells A1 and B1, the cells return the numbers I want to extract from the range:
* the first cell contains the result of INDEX(range,1,1)
* the second one contains the result of INDEX(range,2,1).

I can then obviously make a sum over the two cells to get the result I want.

But when I combine the SUM and the INDEX over an array, the formula fails...

Any idea why?

Many thanks,

Chris