Skip to main content

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.

[Computer] [Android][iPhone & iPad]

Note: This feature doesn’t work for some numbers or currency formats.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the cells you want to calculate.
  3. In the bottom right, find Explore Explore. Next to Explore, you'll see "Sum: total."
  4. To see more calculations, click Sum.
    • Average
    • Minimum
    • Maximum
    • Count
    • Count numbers

[See an example]