Array summation issues

[lasttccasey]

Hey guys,

I'm trying to sum an array but the result is just the first value of the array. The code it pretty complex but here it is:

{=INDEX(B11:B16,MATCH(SMALL(B11:B16/C11:C16,ROW($A$1:INDIRECT("A"&$B$9))),(B11:B16/C11:C16),0))}  [I](Ctrl+Shift+Enter)[/I]

This part works fine, it forms a cell with an array of two numbers {2.5,3.5}. The issue arises when I try to sum them to get the value of 6. This is what I'm trying to do:

{=SUM(INDEX(B11:B16,MATCH(SMALL(B11:B16/C11:C16,ROW($A$1:INDIRECT("A"&$B$9))),(B11:B16/C11:C16),0)))}  [I](Ctrl+Shift+Enter)[/I]

This results in the same array, {2.5,3.5}. Now I've checked the following to code to see if it's possible and I did in-fact get a value of 6:

{=SUM({2.5,3.5})}

Aside from expanding the array into two cells and summing the two cells, I can't get it to sum the two numbers. It seems to be summing each individual value in the array, any ideas on how to fix this?

Thanks!