• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel Multi Cell Array Formula Step by Step Tutorial

#### 1 of 4

Excel Array Formulas Overview

Excel Multi Cell Array Formula Tutorial

### Excel Array Formulas Overview

In Excel, an array formula carries out calculations on one or more elements in an array.

Array formulas are surrounded by curly braces "{ } ". These are added to a formula by pressing the CTRL, SHIFT, and ENTER keys after typing the formula into a cell or cells.

### Types of Array Formulas

There are two types of array formulas - those that are located in a single cell of a worksheet (single cell array formula) and those located in multiple cells (multi cell array formula).

### How a Multi Cell Array Formula Works

In the image above, the multi cell array formula is located in cells F1:F3 and it carries out the same mathematical operation of multiplication on the data in the ranges of D1:D3 and E1:E3.

Because it is an array formula, each instance or copy of the formula uses different data in its calculations and each instance produces different results.

For example:

• The instance of the array formula in cell F1 multiplies the data is cell D1 by the data in cell E1.
• The instance of the array formula in cell F2 multiplies the data is cell D2 by the data in cell E2.
• The instance of the array formula in cell F3 multiplies the data is cell D3 by the data in cell E3.

### Multi Cell Array Formula Tutorial

The following steps in this tutorial cover creating the multi cell array formula seen in the image above.

Tutorial Topics

Ted French