neilhousden
New Member
- Joined
- Feb 25, 2014
- Messages
- 11
I was trying to grab a range of data using an array as an input to an INDEX (the array in the real formula comes from a MATCH). But the formula I came up with only returns the first hit (Cell A1): answer 1 rather than the sum of rows 1 and 2 as I intended. This is regardless of whether I ENTER or CSE the formula, or even wrap the INDEX in "N()". Is there a way I can grab multiple cells in one INDEX function? I was trying to avoid volatile functions since I have tens of thousands of data points in several tables.
=SUMPRODUCT(INDEX(A1:C4,{1,2},1))
Data rows 1-4 of columns A-C:
<TBODY>
</TBODY>
=SUMPRODUCT(INDEX(A1:C4,{1,2},1))
Data rows 1-4 of columns A-C:
1</SPAN> | 1</SPAN> | 1</SPAN> |
2</SPAN> | 2</SPAN> | 2</SPAN> |
3</SPAN> | 3</SPAN> | 3</SPAN> |
4</SPAN> | 4</SPAN> | 4</SPAN> |
<TBODY>
</TBODY>