1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Single Cell Array Formula Step by Step Tutorial


4 of 4

Creating the Array Formula
Creating the Array Formula

Creating the Array Formula

© Ted French

Creating the Array Formula

The last step in the tutorial is turning the sum function located in cell F1 into an array formula.

Creating an array formula in Excel is done by pressing the CTRL, SHIFT, and ENTER keys on the keyboard.

The effect of pressing these keys together is to surround the formula with curly braces: { } indicating that it is now an array formula.

Tutorial Steps

For help with these steps see the image above.

  1. Hold down the CTRL and SHIFT keys on the keyboard then press and release the ENTER key to create the array formula.

  2. Release the CTRL and SHIFT keys.

  3. If done correctly cell F1 will contain the number " 71 " as seen in the image above.

  4. When you click on cell F1 the completed array formula { =SUM (D1:D3 * E1:E3) } appears in the formula bar above the worksheet.

©2014 About.com. All rights reserved.