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

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

Type '=SUM(' in A16

Click B2, and then drag to select B2 to B5. Excel enters the range address for you.

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