How to use sum in excel

August 2, 2022
776 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

The sum function allows you to total all the assigned cell values or range. Whether there are group of cells or individual cells in different locations or even combination of both, the Sum function will total it all. If you are wondering how to use sum in excel, this is the article for you.

In this article various types of excel SUM function will be discussed and eventually put an end to your question how to use sum in excel. So let’s get started.


Use Sum function to add two cells

1. Open the document your want to use sum function. This example document just shows series of numbers in random.

2. Click on the cel C12 to get your Sum there.

3. Type “=sum”, the sum function is shown in the function field box.

4. Press Tab, the sum function is highlighted.

5. Let’s say you want to add 12.7 and 9.5. Click on C5 to select 12.7.

6. Now type comma to separate the value and click cell C6 to select 9.5.

7. Press Enter key. The sum of two values is calculated and shown.

Use Sum function to add two cells and a separate number

1. Open the document your want to use sum function. This example document just shows series of numbers in random.

2. Click on the cel C12 to get your Sum there.

3. Type “=sum”, the sum function is shown in the function field box.

4. Press Tab, the sum function is highlighted.

5. Now select click C7, insert comma, and then click C8. Your function should look like this.

6. Now again put the comma and add 45 as an individual number.

7. Press Enter key. The result is shown.


Use Sum function to add range of cells

1. Open the document your want to use sum function. This example document just shows series of numbers in random.

2. Click on the cel C12 to get your Sum there.

3. Type “=sum”, the sum function is shown in the function field box.

4. Press Tab, the sum function is highlighted.

5. Now click on the cell C5.

6. Press and hold left mouse button and drag down to C10.

7. Now press Enter key. The complete range of cell is selected and its total shown.


Use Sum function to add multiple range of cells

1. Open the document your want to use sum function. This example document just shows series of numbers in random.

2. Click on the cel C12 to get your Sum there.

3. Type “=sum”, the sum function is shown in the function field box.

4. Press Tab, the sum function is highlighted.

5. Now click on the cell C5, hold and drag left mouse button and drag down to C10. The cell range is selected.

6. Now for the 2nd cell range, insert comma and click on the cell E5, hold left mouse button and drag down to E10, this cell range is also selected.

7. Now hit Enter key. The total of both cells are shown.


So this is how to use sum in excel. Need to edit Word/Excel/PPT file free of charge? Download WPS Office edit files like without any cost. Download now! to get enjoyable working experience.