## Using Array Formulas

Posted by
Sokhom
Labels:
Functions

January 2008 BUDGET =

**C11*$C$3**

February 2008 BUDGET =

**D11*$C$3**

March 2008 BUDGET =

**E11*$C$3**

You can replace all three formulas with a single array formula by following these steps:

- Select the range that you want to use for the array formula. In the 2008 BUDGET example, you’d select
**C13:E13.** - Type the formula and, in the places where you would normally enter a cell reference, type a range reference that includes the cells you want to use. Don’t—I repeat, don’t— press Enter when you’re done. In the example, you’d enter =
**C11:E11*$C$3.** - To enter the formula as an array, press Ctrl+Shift+Enter. The 2008 BUDGET cells (C13, D13, and E13) now all contain the same formula:
**{=C11:E11*$C$3}**

Subscribe to:
Post Comments (Atom)

Post a Comment