How To Total A Column In Google Sheets

Google Sheets is a powerful tool that allows users to create, manage and manipulate spreadsheets online. One of the key functions in Google Sheets that can save a lot of time is the ability to total a column. This is a simple yet important function that enables you to automatically calculate the total of a column without having to manually add up each value. This blog post will guide you on how to total a column in Google Sheets.

Steps to Total a Column in Google Sheets

Step 1: Open Google Sheets

The first step is to open Google Sheets. You can do this by going to the Google Sheets website and clicking on the “Go to Google Sheets” button. If you are not already signed in to your Google account, you will need to do so.

Step 2: Select Your Spreadsheet

Next, you need to select the spreadsheet that contains the column you want to total. If you have not yet created a spreadsheet, you can do so by clicking on the “+ New Spreadsheet” button.

Step 3: Select the Cell for the Total

Select the cell where you want the total to appear. This is typically the cell right below the last entry in the column you want to total.

Step 4: Input the SUM Formula

In the selected cell, type an equals sign (=), then type “SUM” followed by an opening parenthesis “(“.

Step 5: Select the Column’s Cells

Click and drag to select all the cells in the column that you want to total. Once you have selected all the cells, type a closing parenthesis “)”.

Step 6: Hit Enter

Press enter to apply the formula. The total of the column should now appear in the cell you selected.


Suppose you have a column of numbers in cells A1 to A5, and you want the total to appear in cell A6. In cell A6, you would type the following formula:


Press enter and the total of cells A1 to A5 will appear in cell A6.


Knowing how to total a column in Google Sheets can save you a lot of time and effort, especially when dealing with large datasets. Once you have mastered this basic function, you can start exploring other powerful functions in Google Sheets. Happy spreadsheeting!