EXCEL SUM FUNCTION

The sum is an Excel function to sum the values in a specific range.

Syntax:

=sum(number1,[number2],[number3],,)

Arguments or Parameters:

number1: first range to sum.
number2 [optional]: Second range to sum.

Note: To use the Sum function, make sure you are selecting cells that contain only numbers.

Objective: Find the Total Sale of the Product in cell H2.

Step 1:

Type = sign in H2 cell
Type Sum Function

Step 2:

Select range E2:E22
Type “)”
Press Enter

Conclusion: The Sum Function has given the Total Sale of Product as $2,438.00 in the H2 cell.