Select a range. Give it a name in name box and press Enter
Type '=SUM(' in A16
Press F3 to display a list of named ranges.
Click the name of the range you want to insert. Click OK.
Complete the formula by entering a close parentheses. Then click the Enter button.