Sumproduct - Why does one formula use CSE and another one does not

[bearcub]

I'm trying to understand when CSE is and is not required for the Sumproduct function to return the correct result.

From what I understand in most cases Sumproduct does not require CSE for it to function properly. However, the one instance CSE is required for Sumproduct is when the"IF" function is nested within it and one of the IF arguments contains an array.

These are the two formulas that I just encountered which brought about my question:

={SUMPRODUCT(IF($B$2=1,TRUE,Table1[Country]=INDEX($E$1:$E$11,$B$2))*(Table1[Sales stage]="Won")*(Table1[Deal size]<250)*(Table1[Sales Channel]=E$88))}

SUMPRODUCT((Table1[Country]=A22)*(Table1[Sales stage]="Won")*(IF(A2=1,Table1[Deal size],1)))

Is my analysis correct:

The first formula has the Index function as one of its arguments and it is being used as an array. CSE is needed

In the 2nd formula, the If function doesn't contain an array just a range. CSE is not needed.


Thanks for your help in advance,

Michael