
To total a column in Google Sheets, use the SUM function. Click an empty cell where you want the total, type =SUM(, select the column range, close the formula so it looks like =SUM(A1:A10), and press Enter.
Replace A1:A10 with your actual range. If you add new values, update the formula by expanding the range or using an open-ended reference like =SUM(A:A).
Curious to learn more? Check out: Google Spreadsheet Checkbox Formula
Enter the SUM Formula Manually
- 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), replacing A1:A10 with your actual range.
- Press Enter, and the sum of all the numbers in that column will be displayed in the selected cell.
Use the Actual Column Range
Replace A1:A10 with your actual range. An open-ended reference such as A:A is an option when appropriate.
Related reading: Lock Google Sheet Column
Include Newly Added Values
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).
Frequently Asked Questions
What formula do I type to add up a column in Google Sheets?
Type =SUM(, 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), and press Enter. The sum of the numbers in that column will appear in the selected cell.
Where should I put the total formula for a column?
Click an empty cell where you want the total to appear, usually at the bottom of the column, and enter the SUM formula there.
How do I make the total update when I add new values to the column?
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).
Can I use an open-ended reference instead of a fixed range?
Yes. An open-ended reference such as A:A is an option when appropriate, and it can help include newly added values without manually expanding the range.
Featured Images: pexels.com


