Back to product guides

Google Sheets Formulas

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.”

- Type “=SUM”* or go to the “Insert” → “Function” → “SUM” function.
- 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.
- Press the Enter key on your keyboard.

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

**Generic formula**

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

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.

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)**”.

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 👇

Our team of real people are here to help you any time between 9am and 10pm GMT.

Email us at: founders@liveflow.io

Call us at +1 (415) 650-1711