How to Sum a Column
in Google Sheets
Open your Google Sheets document and navigate to the column you want to sum.
Click on an empty cell where you want the total to appear, usually at the bottom of the column.
Type
=SUM(
and then select the range of cells in the column by clicking and dragging over them.Close the formula with
)
so it looks like=SUM(A1:A10)
, replacingA1:A10
with your actual range.Press Enter, and the sum of all the numbers in that column will be displayed in the selected cell.
If you add new values to the column, update the formula by expanding the range or using an open-ended reference like
=SUM(A:A)
.