1. Computing

Excel Multi Cell Array Formula Step by Step Tutorial

By

1 of 4

Excel Array Formulas Overview
Excel Multi Cell Array Formula Tutorial

Excel Multi Cell Array Formula Tutorial

© Ted French

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

  1. About.com
  2. Computing
  3. Spreadsheets

©2014 About.com. All rights reserved.