How to Add Numbers in Google Sheets?

Posted on Latest In Blogs

To add numbers in Google Sheets, you can use the SUM function, which is a built-in formula that adds up a range of cells. Here’s how you can use the SUM function to add numbers in Google Sheets:

  1. Open Google Sheets: Open your Google Sheets document where you want to perform the addition.
  2. Select the Cell: Click on the cell where you want the sum to appear. This is where the result of the addition will be displayed.
  3. Type the SUM Formula: In the selected cell, type the SUM formula in the following format:
    =SUM(range)

    Replace “range” with the range of cells you want to add together. For example, if you want to add the numbers in cells A1 to A5, you would type:

    =SUM(A1:A5)
  4. Press Enter: After typing the formula, press the “Enter” key. The cell will display the sum of the numbers in the specified range.

Example:

Let’s say you have the following numbers in cells A1 to A5:

A1: 10
A2: 15
A3: 20
A4: 25
A5: 30

To add these numbers, you would use the formula:

=SUM(A1:A5)

After pressing Enter, the cell would display:

100

This is the sum of the numbers 10, 15, 20, 25, and 30.

You can also use the SUM function to add non-contiguous cells. For example, if you want to add the numbers in cells A1, B1, and C1, you can use the formula:

=SUM(A1,C1,B1)

Remember that the SUM function is versatile and can be used with various combinations of cell ranges and individual cell references to perform addition in Google Sheets.

Leave a Reply