Use a Range Name in a Formula : Range « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Range

Select a range. Give it a name in name box and press Enter

Type '=SUM(' in A16

Press F3 to display a list of named ranges.

Click the name of the range you want to insert. Click OK.

Complete the formula by entering a close parentheses. Then click the Enter button.

6.12.Range
	6.12.1.	Use a Range in a Formula
	6.12.2.	Use a Range Name in a Formula
	6.12.3.	Calculate a Range Automatically