Arrow left
Back to product guides
Google Sheets Formulas

How to Sum Numbers in Google Sheets

In this article, we will explain how to add up numbers in some cells or numbers in a selected range with a formula called “SUM.”

How to use the SUM function in Google Sheets

  1. Type “=SUM”* or go to the “Insert” → “Function” → “SUM” function.
  2. Then, you can directly type in a range between the brackets or input a range by selecting a field with a cursor or a keyboard.
  3. Press the Enter key on your keyboard.

*You don’t need to add quotation marks when you enter the formula name

Generic formula

SUM(value1, [value2, …])

Value 1: a number, a cell or a range of cells that you want to sum up.

How to add up numbers in Google Sheets

How to add up numbers in Google Sheets

You can see some usages of the “SUM” function in the screenshot above. If you want to sum up a couple of numbers without any functions, you can simply calculate the results by using the plus signs in the screenshot above. To add up numbers in cells B2, C2 and D2, and show the result in cell E2, you can type “=B2+C2+D2” by manually inputting or selecting cell B2 and pressing “+” mark and do the same for other cells (C2 and D2) as shown in the picture above. 

How do I make columns add up in Google Sheets?

As you can see in the picture above (the second formula from the bottom), you can select some columns as a target range to add up.

If you want to sum up numbers in Column B (from Row 12 to 14), Column C (from Row 12 to 14), and Column E (from Row 12 to 14), you can define the formula as “=SUM(B12:B14,C12:C14,D12:D14)”.

How do you make numbers automatically add up in sheets?

If you in advance select a range including cells that you will fill in with numbers later, when you input any numbers in any cells in the selected range, all numbers are summed up automatically by the SUM formula. For example, let’s assume that you set the following SUM formula “=SUM(B16:D18)” in which B16:D18 means a range of total nine cells (three rows in three columns - B16, B17, B18, C16, C17, C18, D16, D17 and D18) and all cells in the range are blank. If you input any figures in the range later, the numbers typed in are automatically summed up and you can see the aggregated number in the cell you input the formula.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711