In Google Sheets, you can add up a column of numbers using the **SUM** function. The **SUM** function has the following syntax:

```
=SUM(number1, number2, ...)
```

Where:

**number1**is the first number that you want to add.**number2**is the second number that you want to add.**…**is an optional list of additional numbers that you want to add.

For example, to add up the values in cells A1 to A10, you would enter the following formula into cell A11:

```
=SUM(A1:A10)
```

This formula would return the sum of all of the numbers in cells A1 to A10.

You can also use the **AutoSum** button to quickly add up a column of numbers. To do this, select the column of numbers that you want to add up, and then click the **AutoSum** button in the toolbar.

**Here are some additional tips for adding up a column in Google Sheets:**

- You can use the
**Ctrl**+**Shift**+**+**keyboard shortcut to enter the**SUM**function. - You can use the
**F2**key to edit a formula. - You can use the
**Ctrl**+**Enter**keyboard shortcut to enter a formula into multiple cells.

**Adding up a column with mixed data**

If the column that you want to add up contains mixed data, such as numbers and text, you can use the **SUMPRODUCT** function. The **SUMPRODUCT** function has the following syntax:

```
=SUMPRODUCT(array1, array2)
```

Where:

**array1**is the first array that you want to sum.**array2**is the second array that you want to sum.

For example, to add up the values in cells A1 to A10, where cells A1 to A5 contain numbers and cells A6 to A10 contain text, you would enter the following formula into cell A11:

```
=SUMPRODUCT(A1:A10, A1:A10)
```

This formula would return the sum of all of the numbers in cells A1 to A10, ignoring the text in cells A6 to A10.

**Adding up a column with blanks**

If the column that you want to add up contains blanks, you can use the **COUNTA** function to count the number of non-blank cells in the column. Then, you can use the **SUM** function to sum the values in the non-blank cells.

For example, to add up the values in cells A1 to A10, where cells A2 to A5 contain blanks, you would enter the following formulas into cells A11 and A12:

```
=COUNTA(A1:A10)
```

```
=SUM(A1:A10, A6:A10)
```

These formulas would return the number of non-blank cells in cells A1 to A10, and the sum of the values in the non-blank cells.

**Adding up a column with a range of values**

If you want to add up a column of numbers that has a range of values, you can use the **SUMIF** function. The **SUMIF** function has the following syntax:

```
=SUMIF(range, criteria, [sum_range])
```

Where:

**range**is the range of cells that you want to sum.**criteria**is the criteria that you want to use to select the cells that you want to sum.**[sum_range]**is an optional range of cells that you want to sum. If you omit**[sum_range]**, the**SUMIF**function will sum the values in the**range**.

For example, to add up the values in cells A1 to A10, where the values are greater than 10, you would enter the following formula into cell A11:

```
=SUMIF(A1:A10, ">10")
```

This formula would return the sum of all of the values in cells A1 to A10 that are greater than 10.