What is an Array?
Anarrayis a collection of more than one item.
Arrays in Excel appear inside curly brackets.
The reason arrays are so common in Excel is that they map directly to cell ranges.
A two-dimensional range will use both semicolons and commas.
Examples
Array formulas are somewhat difficult to understand because the terminology is dense and complex.
But array formulas themselves can be very simple.
Sometimes array formulas supply multiple values as a function argument.
The SUM function then sums all items and returns 43 as the final result.
check that you do not enter the curly braces manually!
Not all array formulas need to be entered with Control + Shift + Enter.
For a general introduction, seeDynamic Array Formulas in Excel.
