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.
- Hold down the CTRL and SHIFT keys on the keyboard then press and release the ENTER key to create the array formula.
- Release the CTRL and SHIFT keys.
- If done correctly cell F1 will contain the number " 71 " as seen in the image above.
- When you click on cell F1 the completed array formula { =SUM (D1:D3 * E1:E3) } appears in the formula bar above the worksheet.
