How to use the SUM function
A free Office suite fully compatible with Microsoft Office
· Option 1:
1. Select the cell range with data to sum up.
2. Click Formula → AutoSum
You can also use theSUM 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.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Check if value is in list in Excel (3 easy methods)