# How to Sum Numbers, Cells, or Matrices in Google Sheets

Rate this post

One of the four fundamental operations in mathematics is addition. There are several techniques for adding or summing numbers. The simplest technique is to use the plus symbol (+), as you would when adding numbers on paper. Alternatively, you may use functions like the Add function to sum values.

In Google Sheets, you can sum cells and even matrices in addition to numbers. Summing in Google Sheets extends well beyond these, but they will sufficient for the purposes of this essay.

## How to Sum Numbers in Google Sheets

In Sheets, you may sum simple integers using the formula bar. Google Sheets will compute the result and display it in the cell where you entered the formula. Let’s start with a simple example: add 29 and 142 in Sheets.

1. Select a cell where you want to show the result.
2. Click the formula bar.
3. Type in an equal sign (=). This will initiate your formula.
4. Type in the two numbers that you want to sum, with a plus sign (+) in the middle. The formula for this example will be as below: =29+142

You may also use this method to add numerous numbers by adding another plus sign (-) and inputting the third number, and so on.

## How to Sum Cells in Google Sheets

Instead of inputting the numbers and getting a static answer, you may refer to the cells containing these values and develop your own dynamic formula. If you update the cells to which your sum operation refers, the results will change in real time.

8 Search Engines That Rocked Before Google Even Existed

You may still use the plus sign if you want to sum a range of cells. Simply refer to cells in the formula, put a + sign between them, and repeat until you’ve included all the cells you want in your formula. A skilled Google Sheets user, on the other hand, might employ a function like SUM to make the process easier.

### How to Sum in Google Sheets With the Plus Sign

Assume you have the monthly earnings of a part-time worker. This fictitious worker did not spend any of his money and earned a sizable bonus in May. The idea is to figure out how much money the worker has made in total.

1. Choose the cell in which you want Google Sheets to show the result. As previously stated, this will be cell B7 in our case.
2. Enter the following formula in the formula bar: =B2+B3+B4+B5+E5 This formula will add the monthly earnings (from B2 to B4) to the award in cell E5.

### How to Sum Cells Using the SUM Function in Google Sheets

SUM is a fundamental function in Google Sheets. SUM takes a range of cells and adds the values, returning the total in a cell. The SUM function is simple to use and contains few variables. However, it is an important function to master since it may be used to generate intricate formulae.

`=SUM(value, [value2], ...) `

The other values are optional except for the first. In the SUM function, you may input different ranges of numbers, as seen below:

`=SUM(A1:A8, B2:B10)`

Or a single range like below:

`=SUM(A1:A8)`

Or single values like below:

`=SUM(J7, G12, 14)`

In the preceding example, let’s utilize the SUM function. The purpose here is to determine the worker’s total profits by adding his monthly pay and his unique award. However, to make things simpler this time, we’ll use the SUM function.

1. Choose the cell where you wish the result to appear. For this case, it will be cell B7.
2. Enter the following formula in the formula bar: =SUM (B2:B5, E5) This formula will add the numbers in cells B2 to B5, then add the result to cell E5, yielding the total cash earned.

## How to Sum Matrices in Google Sheets

A matrix is a collection of data placed in a table. Because it includes an array of integers, a matrix is considered an array. To sum matrices, they must have the same structure; if your first matrix is a 22, the second one must also be a 22. The total result will also be a matrix of 22.

Despite its strength and power, the SUM function cannot sum arrays or matrices. To sum matrices, you must use the usual plus sign (+) and an array formula.

In a spreadsheet, for example, we have two matrices (matrix 1 and matrix 2). The objective is to add the two matrices and show the resulting matrix as matrix 3. It’s worth noting that matrices 1 and 2 are the same size.

1. Choose the first cell in the matrix to see the results. In this example, matrix 3 begins at A10.
2. Enter the following formula in the formula bar and hit Enter: A2:C4 + E2:G4 =ARRAYFORMULA This formula adds matrix 1 (A2 to C4) and matrix 2 together (E2 to G4).To show that it is an array formula, the summation is placed within the ArrayFormula function. This informs Google Sheets that it is working with an array rather than a single value.
3. You might alternatively input the standard formula and then hit Ctrl + Shift + Enter. This key combination will automatically insert the formula into the ArrayFormula function.
4. Google Sheets will sum the two matrices and show the result in matrix 3 whenever you click Enter or Ctrl + Shift + Enter, depending on your formula.
4 Easy Ways to Search in Google Sheets (With Examples)