How to Sum a Column in Google Sheets

Type in all the data you need to sum. Make sure there are no mistakes.

Select the cell in which you want the sum to appear. In this case, I created a “Total” column so the results would appear there.

Go to the toolbar and look for the “Function” button. On the desktop, it is on the right side of the formatting bar and looks like the Greek letter sigma (∑). In this case, it is under the three vertical dots button.

Click the ∑ button and a dropdown menu will appear.

Scroll all the way down to “Math”

Click "SUM"

Click the first cell you want to include in the sum. Whatever cell you click on, it will automatically be included in the SUM function.

After clicking the first cell you wish to sum, drag the cursor all the way to the last cell you wish to include in the sum. Automatically, they will be included in the sum function.

Press [[enter]] and the sum result will automatically appear in the cell.

Google Sheets will probably suggest to autofill the remianing cells. Feel free to use it if it’s convenient.

After clicking the autofill suggestion, all the remaining cells will automatically show the sum results for their corresponding rows.