Simplifying a Formula with Ranges

You can simplify formulas by using ranges and range names . For example, if 12 cells on your worksheet contain monthly budget amounts and you want to multiply each amount by 10 percent, you can insert one range address in a formula instead of inserting 12 different cell addresses, or you can insert a range name. Using a range name in a formula helps to identify what the formula does; the formula =1997 SALES * .10, for example, is more meaningful than =D7:O7*.10.

Use a Range in a Formula

Type an equal sign (=), and then type a function (such as SUM).

Click the first cell of the range, and then drag to select the last cell in the range. Excel enters the range address for you.

Complete the formula, and then click the Enter button on the formula bar, or press Enter.

Use a Range Name in a Formula

Type an equal sign (=), and then type the function you want to use.

Press F3 to display a list of named ranges.

Click the name of the range you want to insert.

Click OK.

Complete the formula, and then click the Enter button on the formula bar or press Enter.