Forum Discussion
Sumif input from a table
You cannot enter any expression/formula in a literal array {...}. The solution is simple: remove the { }.
=SOMMEPROD(SOMME.SI($A:$A; SIA[Phases SIA]; F:F))
You cannot enter any expression/formula in a literal array {...}. The solution is simple: remove the { }.
=SOMMEPROD(SOMME.SI($A:$A; SIA[Phases SIA]; F:F))
Microsoft's documentation: Use array constants in array formulas
The name "array constants" indicates that the elements of the array must be constant, not expressions.
Also see Array constant:
Array constant limitations
The curly braces surrounding an array constant signify "constant" to Excel's formula parsing engine. As a result, you can't include references or functions in an array constant, since doing so would make an array constant variable (i.e. not a constant).