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
