How To Sum In Google Sheets?

Select the cell where you want the total

Type `=SUM(`

Select the range of cells you want to add

Close the formula with `)`

Press Enter

Example: `=SUM(A1:A10)`

To sum non-adjacent cells, use `=SUM(A1,A3,A5)`

To sum an entire column, use `=SUM(A:A)`

To sum an entire row, use `=SUM(1:1)`

You can also click the Sigma button in the toolbar and choose Sum

You can use AutoSum by selecting a blank cell below or beside your numbers and pressing `Alt` + `=` on Windows or `Option` + `=` on Mac

Suggested for You

Trending Today