Array Formulas

Formulas may include functions that operate on arrays. An array formula is a formula that can perform multiple calculations on one or more of the items in an array.