Referring to the below screenshot, I have a question about Index Function in MS Excel. Can INDEX actually return an Array? e.g. I have numbers in cells A1:A5 as seen in the screenshot. In Cells C1:C5 I put an Array Formula

```
{=INDEX(A1:A5,ROW(A1:A5))}
```

and it successfully returns numbers from A1:A5, indicating that INDEX can return an array in a set of cells.

However when I use a formula like this one

```
{=SUM(INDEX(A1:A5,ROW(A1:A5)))}
```

I was expecting return value of 15 but I get only the first element of the array i.e. 1.

Is this how it is? Can INDEX return an Array that can be used in other Array based formulas?

`=SUM(INDEX(A1:A5,N(IF(1,ROW(A1:A5)))))`

- see this question for more: stackoverflow.com/questions/47187863/… – barry houdini Dec 4 '17 at 11:58