USE A RANGE IN A FORMULA

Prev Show Me Step-By-Step Next
Get Ready
Enter the portion of the formula that comes before the range.
Example: =SUM(

Begin
To use a range name:
Type the name
Example: LastYear
Type )
To select the cells:
Click the first cell in the range.
Example: A1
Type :
Click the last cell in the range.
Example: A15
Type )
To type the cells:
Type the first cell in the range.
Example: A1
Type :
Type the last cell in the range.
Example: A15
Type )
If necessary, enter the rest of the formula.
Press the Enter key.