Excel Function

SUM

Returns the sum of selected values or ranges.

SUM(number1, [number2], ...)

Arguments

number1

Required

Specify the first number or range to calculate.

number2

Optional

Optional second argument; leave blank when not needed.

Practice Preview

calculate the total sales. Use SUM to Returns the sum of selected values or ranges. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SUM(D2:D8)

Practice This Function

Practice in Sequential Mode Back to Function List