What is an Array Formula in Excel??? – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial introducing array formulas. We’ll go over what an array formula is in Excel, how to use one, and end with some tips to keep in mind when using array formulas.

First, in Excel an array refers to a group of values – they could be in a row, column or both. An array formula is a formula that will perform calculations on the array.

Array formulas can help you use fewer formulas in your spreadsheets, potentially helping your file stay smaller and run faster as well as help you work faster. But there are a few things to consider when working with array formulas.