Dec 01 2020 01:49 PM
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.
Nov 05 2023 03:56 PM
Nov 06 2023 01:59 PM
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.