Select a range. Give it a name in name box and press Enter
![Give it a name in name box](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Use_Range_Name_In_Formula___Give_It_Name_In_Name_Box.PNG)
Type '=SUM(' in A16
![Type '=SUM(' in A16](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Use_Range_Name_In_Formula___Type_sum_In_A16.PNG)
Press F3 to display a list of named ranges.
![Press F3 to display a list of named ranges.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Use_Range_Name_In_Formula___Press_F3_To_Display_List_Of_Named_R.PNG)
Click the name of the range you want to insert. Click OK.
![Click the name of the range you want to insert. Click OK.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Use_Range_Name_In_Formula___Click_Name_Of_Range_You_Want_To_Ins.PNG)
Complete the formula by entering a close parentheses. Then click the Enter button.
![Complete the formula by entering a close parentheses. Then click the Enter button.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Use_Range_Name_In_Formula___Complete_Formula_By_Entering_Close_.PNG)