How to use the SUM function

September 28, 2021
161 Views 0

Graphic skills

· Option 1:

1. Select the cell range with data to sum up.

2. Click Formula → AutoSum

How to use the Excel SUM function 1.gif

 

You can also use the SUM function for multiple rows at the same time.

How to use the Excel SUM function 2.gif

 

· Option 2:

1. Choose the cell for sum up result.

2. Input =SUM(B2:E2) .

3. Press Enter on the keyboard.

How to use the Excel SUM function 3.gif


* If you want to get the rest of the results quickly, place the cursor at the down-right corner of F2 until symbol “+” present. Then, change the selected range with the mouse. 

How to use the Excel SUM function 4.gif



To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.