Forum Discussion

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Dec 01, 2020

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' ...
excel
RecalcOrDie's avatar
RecalcOrDie
Iron Contributor
Nov 05, 2023
just checking here, but no news on this Maestro Peter?
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Nov 06, 2023

    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.

Resources