Using a Range Name in a Formula

To use a range Name in a formula:

1. Define the following range Names for ranges B2:B11, C2:C11, and D2:D11 respectively: Jan_2004, Feb_2004, and Mar_2004 (see the screenshot below).
2. Select a cell and type the formula =SUM.
3. Press <Ctrl+A>.
4. Select the first argument box and press <F3>.
5. Select the Name Jan_2004, and then click OK.
6. Paste the Names Febr_2004 and Mar_2004 in the next two argument boxes, and then click OK. The following formula has now been inserted into the cell:

=SUM(Jan_2004, Feb_2004, Mar_2004)