An array constant is a hard-coded set of values provided in an Excel formula.
You’ll want to deal with these arrays using another function that handles arrays natively.
not a constant).
More examples
The formula in the screenshot is explainedhere.
Another example ofarray constants inside the COUNTIFS function.
