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.