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

- 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 the Excel SUM Function In Formula To Add Cells.

- If thousands of cells need to be added, 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. - 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.

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

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