Search
Clear search
Close search
Google apps
Main menu

See the sum of cells in a spreadsheet

You can quickly calculate the sum of cells, the average, and more in Google Sheets.

On the web
  1. Open a spreadsheet in Google Sheets.
  2. Select the cells you want to calculate.
  3. In the bottom right corner of your browser, the "Sum" button will show the total.
  4. Click Sum to see other calculations such as:
    • Average
    • Minimum
    • Maximum
    • Count
    • Count numbers

Note: This feature may not work for some number or currency formats.

Android or iPhone & iPad
  1. Open a spreadsheet in the Google Sheets app.
  2. Select the cells you want to calculate.
  3. At the bottom of the screen, you can see these values:
    • Sum
    • Average
    • Minimum
    • Maximum
    • Count
  4. To add a calculation to a cell:
    • Drag the calculation to the cell.
    • Touch the calculation and it will be added to a cell next to the data.

Note: To hide the calculations, tap Function .

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?