See the sum & average


Want advanced Google Workspace features for your business?

Try Google Workspace today!



You can quickly calculate the sum, average, and count in Google Sheets.

  1. On your iPhone or iPad, open a spreadsheet in the Google Sheets app.
  2. Highlight the cells you want to calculate.
  3. At the bottom, you’ll see a row of calculations.
    • Sum
    • Average
    • Maximum
    • Minimum
    • Count
  4. To add a calculation to a cell, drag it to a cell.
  5. Optional: To hide the row of calculations, tap Formula Formula.

Related articles

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu
Search Help Center