Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
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 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.
Also Read:
- 1. How to sum if cell contains text in Excel?
- 2. How to Use Sum Function in Excel
- 3. How to quickly sum the table data in WPS Writer
- 4. How to add numbers in column in excel (Sum Formula Examples)
- 5. Top 10 leading excel Sum Formula templates
- 6. How to add sum in excel with easy formulas (3 examples)