How to use the SUM function

September 28, 2021

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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