You can also use cell references to add in Google Sheets, which means that you can tell Google Sheets to add the number, in one cell, to a number in another cell. For example, if you wanted to add the numbers 1 and 2 together, you would simply enter the formula shown below into a spreadsheet cell.Īfter entering the formula above, your spreadsheet will display the number 3 in the cell that contains the addition formula. The most simple addition formula, adds one number to another number, where the numbers are typed directly into the formula. In this article we will stick to using addition as well as the SUM function.

In Google Sheets, the four major mathematical operators that you can use to do math, are as follows:Ĭlick here if you want to learn how to do every different kind of math in Google Sheets. Using mathematical operators to add in Google Sheetsįirst, we will start with the most basic and common way of adding in Google Sheets, which is by using the plus sign (+), which is a mathematical operator.

For example you could type a formula like =A1 +2, which would add 2 to the number that is inside cell A1. The Google Sheets SUM function description:įormula summary: “Returns the sum of a series of numbers and/or cells.” Addition formula in Google Sheets:īelow is a diagram that shows how addition formulas work in Google Sheets.Īs you can see, you can use the plus sign to add together numbers, or you can also add together cells (the numbers within them), or you can use a combination of the two. The Google Sheets SUM formula:īelow is a diagram that shows how the SUM function works.Īs you can see, to use the SUM function all you need to do is to specify the range of cells that contain the numbers you want to sum, and the SUM function will automatically sum / add up all of the numbers that are in the range that you specified. Press enter on the keyboard, and Google Sheets will sum the specified range, with a SUM formula that looks like this =SUM(A1:A)Ĭlick here to get your free Google Sheets cheat sheetįurther below are detailed examples of how to add and sum in a variety of ways.Type the range of cells that contain the numbers you want to sum / add up, such as A1:A.To sum in Google Sheets, follow these steps:

How to add shapes in google sheets