How to use the SUM function

September 28, 2021

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.

How to use the Excel SUM function 2.gif

· Option 2:

1. Choose the cell for sum up result.

2. Input =SUM(B2:E2).

3. Press Enter on the keyboard.

How to use the Excel SUM function 3.gif

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

How to use the Excel SUM function 4.gif

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

Was this helpful?