Explanation
An array formula is a formula that can perform multiple calculations on one or more of the items in an array.
We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.
Array formulas can return either multiple results or a single result.