How to use the SUM function
· Option 1:
1. Select the cell range with data to sum up.
2. Click Formula → AutoSum
You can also use the SUM function for multiple rows at the same time.
· Option 2:
1. Choose the cell for sum up result.
2. Input =SUM(B2:E2) .
3. Press Enter on the keyboard.
* 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.
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.