Make a quick calculation in a spreadsheet

You can quickly calculate the sum, average, and more for selected data in a spreadsheet. At the moment, this feature is available on computers and Android devices.

Computer

  1. Open a spreadsheet.
  2. Select the cells of data you want to calculate.
  3. In the bottom right, you can see the sum of the data.
  4. Click the sum to see other possible calculations. These calculations can include:
    • Average
    • Minimum
    • Maximum
    • Count
    • Count numbers
You can also get many of these calculations and add them to your spreadsheet using Explore in Sheets.

Note: This feature is turned on based on your location and may not work for certain number or currency formats.

Android

  1. In the Sheets app, open a spreadsheet.
  2. Select the cells of data you want to calculate.
  3. In the bottom left, touch the Formula icon .
  4. A list of calculations appear that can include:
    • Sum
    • Average
    • Minimum
    • Maximum
    • Count
  5. To add a calculation to a cell, either drag it to the cell or touch the calculation and it will be added to a cell next to the data.

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

Was this article helpful?