Using SUM Function
Use the SUM function to sum numbers in a range
Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787.
Sum Function
To create the formula:
Type =SUM in a cell, followed by an opening parenthesis (.
Sum Function
-
To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6).
Argument
-
Type a comma (,) to separate the first argument from the next.
Separate Argument
-
Type the second argument, C2:C3 (or drag to select the cells).
Second Argument
Type a closing parenthesis).
Closing Parenthesis
6. Press Enter to get the result.
Enter to get results