How to Automatically Add Numbers in Google Sheets | Scribe

    How to Automatically Add Numbers in Google Sheets

    • Alai Umerez |
    • 14 steps |
    • 29 seconds

      How to Automatically Add Numbers in Google Sheets Selecting Cells

      1
      Choose the cells with the values you want to sum
      information ordinal icon
      Tip! For non-adjacent cells, hold down **Ctrl** (Windows) or **Cmd** (Mac) while selecting them
      2
      Once you’ve selected more than one cell, a button showing the sum appears next to the "Explore" button in the bottom-right corner of the spreadsheet
      3
      Click the sum button to access other instant calculations, such as: - Average - Minimum - Maximum - Count (cells) - Count (numbers)

      How to Automatically Add Numbers in Google Sheets Using the SUM Formula

      4
      Select the cell where you want your result to appear
      5
      Type "=" and write "SUM" to choose the SUM formula
      6
      Complete the formula by adding in parenthesis the range you wish to sum For this example, the formula is "=SUM (C4:C8)"
      7
      Press [[Enter]]
      8
      Review the result

      How to Automatically Add Numbers in Google Sheets Using the SUM Function

      9
      Select the range you want to sum
      10
      From the toolbar, click on the functions menu
      11
      From the drop-down menu, click on "SUM"
      12
      The SUM formula will automatically appear beneath the highlighted cells
      13
      Press [[Enter]]
      14
      Review the results