A very useful technique for making it easier to refer to cell ranges in formulas (and functions) is to name the cells. The Cell Name feature allows you to assign a name to a cell or cell range. The name then rather than the cell or range address can be used to refer to the cells in a formula.
Naming a cell or cell range is accomplished via the Name command on the Insert menu.
Select the cell or cell range that you will name.
Select Insert, point at Names, and select Define. The Define Names dialog box will open (see Figure 5.7).
Figure 5.7. Enter the name for the cell or cell range in the Define Names dialog box.
Type the name for the cell or cell range in the Name box.
Click Add to ...