Create a formula
- Click the cell in which you want to add a formula.
- Type an equal sign (=).
- Type the formula.
- Press ENTER.
To insert a sum for a range of cells automatically, select the first blank cell that follows the data you want to sum, either below the column of data or to the right of the data in a row, click AutoSum on the spreadsheet toolbar, and then press ENTER.