A formula that operates on a range of values rather than a single cell.
Definition
Performs calculations on multiple values at once and may return one result or many. In Excel 365 and 2021, array formulas spill automatically. In older versions they had to be entered with Ctrl+Shift+Enter.