Coercion of array formulas

Silver Contributor

Am I correct in my assumption/observation that array coercion of the form

 

=SUM(INDEX(A1:A10,N(IF(1,{1,4,8}))))

 

is no longer needed with dynamic arrays?  Or are there still 'hidden corners' where the array formulas block?

 

 

2014 reference.

INDEX: Returning an array of values « EXCELXOR

2 Replies
just checking here, but no news on this Maestro Peter?

@RecalcOrDie 

I probably haven't examined every hidden corner, but I have only thought of coercion a couple of times over the past 5 years and haven't used it at all.  So, unless something really unexpected crops up, it's history.

In the present case

= INDEX(array, {1,4,8})

works well, as does

= SUM(INDEX(array, {1,4,8}))

just as the OP will have established.