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' where the array formulas block?

 

 

2014 reference.

INDEX: Returning an array of values « EXCELXOR

excel

2 Replies

    • 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