# How to sum two or more cell values in Google Sheets

Updated: 07/06/2021 by Computer Hope

In Google Sheets, a user can sum, or add, the values of multiple cells in columns or rows. Calculating a sum is useful in many situations, such as finding total sales, how many products are manufactured, or totaling the time worked. Click a link below to learn how to sum cell values automatically or manually.

## Automatic SUM formula creation

To quickly calculate the total of two or more cells using automatic SUM formula creation, follow the steps below.

- In the Google Sheets spreadsheet, select the cells containing the values you want to total.

- In the format bar, on the far-right side, click the
**Functions**button (Σ). - In the
*Functions*drop-down menu, select**SUM**.

- A SUM formula is automatically created and entered into the spreadsheet. The formula is created below the last cell selected in a column or right of the last cell selected in a row.

- Press
`Enter`to complete the SUM formula creation and display the total of the selected cell values.

## Manual SUM formula creation

To calculate the total of two or more cells by manually entering a SUM formula, follow the steps below.

Tip

Manually entering a SUM formula is helpful if you don't want the formula in a cell immediately below or next to the selected cells.

- In the Google Sheets spreadsheet, select the cell where you want to create the SUM formula and display the cell values total.
- Type
**=SUM(**to start creating the formula. Only enter the open (left) parenthesis and not the close (right) parenthesis yet. - Select the cells containing the values you want to total. The selected cell range or individual cells are listed in the SUM formula as you select them.

- In the cell containing the SUM formula, type a
**close parenthesis**at the end of the formula.

- Press
`Enter`to complete the SUM formula creation and display the total of the selected cell values.