Use this technique to quickly find the sum of an entire column of data in Google Sheets quickly and effectively.

Without further ado, let’s get right into it

## “=SUM(First Cell: Last Cell)”

To fill in the function as quickly as possible you should follow these steps:

**Select where you want to place the sum:**I like to put my sum and calculation cells away from the actual data table.- Use the “=SUM()” Formula: there is another post dedicated to understanding the SUM function.
- Reference the column: What I do is I like to do is click the first cell of teh column I want to sum and then I use the Keyboard Shortcut
**CRTL+SHIFT+DOWN**. That will automatically highlight every cell for you. Alternatively, you could also name the cell range ahead of time (which is what I like to do) and save yourself the hassle in the moment.

Upon entering the formula, you should be provided with a sum of every cell in your desired column.

And there you have it; that is how you find the sum of an entire column within Google Sheets!