How to use the SUM function

September 28, 2021
5.0K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

· 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.