Easy Formula: How to Add with Excel

July 22, 2022
1.1K Views
0

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

If you need to learn the correct way how to add with excel, you are in the right place. Excel is a complete and versatile tool that offers you many mathematical functions to simplify your work. It allows you to add sets of numbers and cell values quickly.

Next, you will be able to know how to add with excel in simple steps.

How to add with excel using the plus sign?

If you need to add a row or column of numbers, Excel will do all the calculations for you. The process of how to add with excel 2016 using the plus sign is as follows:

1. The first thing you need to do is click on the cell in which you want to display the sum

2. Then type the = sign. This will indicate the beginning of a formula.

3. Type the first number you want to add. If you want to add the value of an existing cell, you need to click on the cell you want to include in the equation. Otherwise, you can type the number manually.

4. Type the + sign.

5. Type another number or select another cell. You will add the second number or value to your equation in this step.

If you want, you can add multiple numbers of cells at once. You need to separate each number or cell with a + sign.

6. To finish, you must press Enter or Return. You can see the sum of the added values or numbers in the selected cell.

How to add with excel using the SUM function?

If you want to learn how to add with excel 2019, follow these simple steps:

1. You need to click on the cell where you want to display the sum. The SUM function works like the + sign, but it's easier to use when adding multiple ranges or cells.

2. You will need to type an = sign followed by the word SUM (=SUM). This will point you to the beginning of the SUM formula.

3. Next, you must type an opening parenthesis (. Your formula will look like this: =SUM (.

4. To continue, you must select the range of cells you want to add to your sum. Click and drag over all the cells you want to add. If you want to select multiple non-adjacent rows or columns, you must press the Control key while selecting each range. You can also integrate individual numbers or cell addresses.

5. Write the clothes parenthesis ) to end the formula.

6. To finish with the how to add with excel online, you must press Enter or Return. The sum of the selected range will appear in this cell.

How to add with excel using AutoSum for rows and columns?

Know the steps of how to add with excel mac and Windows using AutoSum for columns and rows correctly:

1. First, you need to click on the cell immediately below or next to the values you want to add. AutoSum will automatically create a formula that adds the values in the adjacent row or column.

2. You will need to click on the Autosum icon in the Home tab Σ. It's in the Home tab at the top of Excel. A formula will appear in the selected cell.

3. To finish, you must press Enter or Return. You will see the results of the formula in the cell.

Were you able to learn how to add with excel? Using any of the 3 options above, you can add and have the results in your spreadsheet. If you want to learn about new Excel features, you can also follow WPS Academy.