Coercion of array formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1946377%22%20slang%3D%22en-US%22%3ECoercion%20of%20array%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1946377%22%20slang%3D%22en-US%22%3E%3CP%3EAm%20I%20correct%20in%20my%20assumption%2Fobservation%20that%20array%20coercion%20of%20the%20form%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(INDEX(A1%3AA10%2CN(IF(1%2C%7B1%2C4%2C8%7D))))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20no%20longer%20needed%20with%20dynamic%20arrays%3F%26nbsp%3B%20Or%20are%20there%20still%20'hidden%20corners'%20where%20the%20array%20formulas%20block%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2014%20reference.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelxor.com%2F2014%2F09%2F05%2Findex-returning-an-array-of-values%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EINDEX%3A%20Returning%20an%20array%20of%20values%20%C2%AB%20EXCELXOR%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1946377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Valued Contributor

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

0 Replies