In this article, I will tell you how to use formulas to add cells in excel. The cells can be a column of cells, a row of cells, or a cell range. The formulas can use the basic cell reference or use the excel **SUM** function to add cell values efficiently.

### 1. Use Basic Formula To Add Cells In Excel.

- Below is the example cell column. Column A contains the numbers from 1 to 10, and we want to add the cells up using a formula.

**A****1**1 **2**2 **3**3 **4**4 **5**5 **6**6 **7**7 **8**8 **9**9 **10**10 - You can input the formula
**=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10**in a cell such as**B1**manually, and press the enter key. - Then it will display the number
**55**in cell**B1**. - If you find the above method is complicated, you can select cell
**B1**and input the text**=**. - Then select cell
**A1**and press the + key, and select cell**A2**and press the**+**key, do this action repeatedly until cell**A10**. - Then it will add the formula
**=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10**in cell**B1**. - If the above data is saved in a row, then the method is similar.
- The above method is useful when there are not too many cells in the formula and the cells are not continuous.
- But if there are thousands of cells to add, how can we do it?

### 2. Use Excel SUM Function In Formula To Add Cells.

- If there are thousands of cells that need to add, you can use the
**SUM**function in the excel formula to do it. - You can pass the cell range ( such as
**A1:C10**) as the parameter to the**SUM**function. - And then the function
**SUM**will add all the number values in the cell range**A1:C10**. - If the cell in the range contains no number value, the
**SUM**function will ignore the value. - We change the example data cell to below, the cell
**A6**contains the text**hello**which is not a number.

**A****1**1 **2**2 **3**3 **4**4 **5**5 **6**hello **7**6 **8**7 **9**8 **10**9 **11**10 - Then input the formula
**=SUM(A1:A10)**in cell**B1**and press the enter key, it still shows the number 55 in cell**B1**. - The excel
**SUM**function can also accept multiple cell ranges as the parameters, for example,**SUM(cell_range1, cell_range2)**. - Then it will add up all the cell ranges number values together and return the result.
- Now we add some numbers in row 1 as below.

**A****B****C****D****E****F****G****1**1 11 12 2022/10 14 15 **2**2 **3**3 **4**4 **5**5 **6**hello **7**6 **8**7 **9**8 **10**9 **11**10 - We input the formula
**=SUM(A1:A11, C1:G1)**in cell**B1**and press the enter key. - Then you can see the number 107 in cell
**B1**. - The
**SUM**function ignores both cell**A6**( contains a text value ) and cell**E1**( contains a date value ).