Entering a range name in a formula

You can use a range name in a formula to refer to data you want the formula to use. More power with formulas describes all the basic parts of a formula and the different types of formulas.

  1. Enter the formula up to the operator or ( (open parenthesis) that precedes the range name you want to enter.

  2. Type the range name.

  3. Complete the formula and press ENTER.

If you delete a range name that a formula uses, your spreadsheet replaces the range name with its associated range address. For example, suppose that SALES is the name of B14..H14, and that your sheet contains the formula @SUM(SALES). If you delete the name SALES, your spreadsheet changes @SUM(SALES) to @SUM(B14..H14).



See also
Naming a range
More power with @functions
When and how formulas recalculate
Controlling how a formula refers to data
Fixing common errors in formulas
Editing a formula
Entering a range address in a formula
Copying a formula
Moving a formula