# Tips for adding in Excel you need to know

Addition is a basic math operation in Excel, and it's usually quite simple. When it comes to addition in Excel, many people often think of the SUM function. However, in reality, there are many other tips around addition operations that if you are proficient, they will help a lot in your work. Here are a few general Excel tips that you should be aware of.

**Addition is within 1 cell**

The easiest way to perform a mathematical operation in a cell is to simply use the plus sign (+). Just enter the basic formula: = x + y. This is the simplest and fastest method for basic addition operations within a cell.

Adds within a cell**Add 2 cells in Excel**

Adding 2 cells is quite similar to adding a range of cells, but you will not type the whole number in the cell, but only the names of the cells to add, for example: = A2 + A3. The beauty of this formula will be automatically updated whenever the data in the cell changes.

Add 2 cells in Excel**SUM function**

Speaking of addition in Excel, it is impossible not to mention the SUM function. There are 2 ways to use this simple calculation function.

**Implement the SUM function with Formula Builder**

1. First, select the cell and navigate to the **Formulas** tab (formula), then click I **nsert Function** .

2. You should now see the **Formula Builder** menu, select **SUM** .

3. At this point, you will see 2 items where you can enter numbers as well as plus signs if you need to add more values.

Enter the number4. Finally, press **Done** and the results will be automatically filled into the box.

**Implement the SUM function without using the Formula Builder**

1. Start with the equal sign, then enter SUM, and be careful not to forget the opening parenthesis and closing parentheses.

2. Pay attention to the cells you plan to assign, and separate each cell with a comma. In the illustrative example, the formula used is = SUM (A2, A3).

= SUM (A2, A3)3. Press enter and you will see your cell is filled with the sum value.

Note, this function can also be done with the format = SUM (first cell: the last cell), which allows you to quickly calculate a large number of consecutive rows or columns. For example, using the formula = SUM (A2: A7) will give you the result of the addition between all numbers from A2 to A7.

Calculate the total series## You should read it

- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Instructions on how to create diagonal lines in Excel box
- How to fix the SUM function doesn't add up in Excel
- Merge cells in Excel
- DCOUNTA function, how to use the function to count non-empty cells in Excel
- How to indent the line in Excel
- How to use the SUBTOTAL function in Excel
- How to keep Excel and Excel columns fixed?
- How to use the LEN function in Excel
- How to use the SUM function to calculate totals in Excel
- Get started with Excel for beginners
- Basic Excel functions that anyone must know

## Maybe you are interested

### DaVinci Resolve 17 video course summary

### Steve Jobs and Bill Gates' 18-year-old resumes are back in the news

### Automatic document summarization with Copilot is now available in Word

### How to use Apple Intelligence to summarize emails, web pages, and text

### Instructions for viewing link summary content on Chrome

### Summary of predicted information about iPhone 17 Slim