Forum Discussion
Coercion of array formulas
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' ...
just checking here, but no news on this Maestro Peter?
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.