Type '=SUM(' in A16 Click B2, and then drag to select B2 to B5. Excel enters the range address for you. Complete the formula by entering a close parentheses. Then click the Enter button.