How to Add Numbers in a Column in Google Sheets

Do you have a bunch of numbers in a column on a Google Sheets and need to add them up? No worries, my friend! I'm here to help. In this article, I'm going to show you how to add numbers in a column in Google Sheets. It's super easy and you'll be a pro at it in no time!

Step 1: Open Your Google Sheet

The first thing you need to do is open your Google Sheet. You can either create a new one or open an existing one. Once you have your sheet open, you'll see a bunch of columns and rows. You need to select the column that contains the numbers you want to add up.

Step 2: Click on the Empty Cell Below the Last Number

After you've selected the column with the numbers, you need to click on the empty cell below the last number. This is where your sum is going to go!

Step 3: Type in the SUM Formula

Now it's time to type in the SUM formula! Don't get scared, it's just a simple formula that will add all the numbers in your selected column. The formula is as follows:


Make sure you replace "range" with the range of cells in your selected column. For example, if your numbers are in cells A1 to A10, your formula should look like this:


Step 4: Press Enter and Voila!

After you've typed in the SUM formula with the correct range, press enter and bam! Your sum will magically appear in the cell you selected in Step 2.

That's it! You've successfully added numbers in a column in Google Sheets. Wasn't that easy?

Bonus Tips:

Here are some bonus tips to help you become a Google Sheets pro:

  • You can also use the AutoSum button to quickly add up a column. Just select the empty cell below the last number and click on the AutoSum button (looks like a Greek sigma sign).
  • If you want to add up numbers in multiple columns, just type in the SUM formula for each column and then add the columns together in the same formula. For example:
  • =SUM(A1:A10,B1:B10,C1:C10)

Now go forth and conquer your Google Sheets with your newfound SUM formula knowledge. You're welcome!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.